Quick little question
 

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

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

Quick little question
 

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531882

Quick little question
 

try this

IF(A251,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