View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default Quick little question

=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)

"ben simpson" wrote in message
...
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