Formula

[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.

 

[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.

 

[Gord Dibben]

=IF(B1="",A1/60,IF(B1>0,B1/60,"B1 is <=0"))


Gord Dibben MS Excel MVP

 

[Trainee]

THANK YOU! good formula 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.

 

[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.