Quick little question

B

ben simpson

What would be the best way to combine the following two formulas?
=IF($A$25=0,"",$A$25) and =IF(AND($C$51>=$C$53,$C$51<$C$52),5,0)

Meaning if cell A25 is blank then leave a blank in this cell, but if there
is a value in A25 then perform the following formula.

Thanks in advance for the help......Ben
 
B

Bob Phillips

=IF($A$25=0,"",IF(AND($C$51>=$C$53,$C$51<$C$52),5,0))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
J

John James

Just drop out the $A$25 you don't want and put the closing bracket at
the end

=IF($A$25=0,"",IF(AND($C$51>=$C$53,$C$51<$C$52),5,0))
 
Top