Formula

  • Thread starter Thread starter Trainee
  • Start date Start date
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.
 
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.
 
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...
 
your welcome
--
Mike

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