Quick little question

[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

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

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

"ben simpson" <[email protected]> wrote in message
news:[email protected]...
> 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

[flow23]

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