Formula

T

Trainee

I'm in need of a formula in C1 that gives me the value of A1 divided into
60 if B1 is empty, however if B1 has a value (not zero) then C1=B1/60.
THANKS.
 
M

Mike H

Hi,

This also checks they aren't both empty

=IF(COUNT(A1:B1)=0,"",IF(B1<>0,B1/60,A1/60))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
T

Trainee

THANK YOU! good formula Mike H.

Mike H said:
Hi,

This also checks they aren't both empty

=IF(COUNT(A1:B1)=0,"",IF(B1<>0,B1/60,A1/60))
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
Click to expand...
 
M

Mike H

your welcome
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Satisfying several criteria 4
IF 4
IF formula 4
need formula returning a blank cell 4
copy and paste the cell with formula ="1" 3
Concatenate strings? 4
Running Balance in a row 1
if then formula 2

Top