try this
IF(A25>1,IF(AND($C$51>=$C$53,$C$51<$C$52),5,0),A25)
"ben simpson" wrote:
> 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
Bookmarks