software

What would be the best way to combine the following two formulas?
=IF($A$25=0,quot;quot;,$A$25) and =IF(AND($C$51gt;=$C$53,$C$51lt;$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

=IF($A$25=0,quot;quot;,IF(AND($C$51gt;=$C$53,$C$51lt;$C$52),5, 0))--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;ben simpsonquot; gt; wrote in message
news
gt; What would be the best way to combine the following two formulas?
gt; =IF($A$25=0,quot;quot;,$A$25) and =IF(AND($C$51gt;=$C$53,$C$51lt;$C$52),5,0)
gt;
gt; Meaning if cell A25 is blank then leave a blank in this cell, but if there
gt; is a value in A25 then perform the following formula.
gt;
gt; Thanks in advance for the help......Ben

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

=IF($A$25=0,quot;quot;,IF(AND($C$51gt;=$C$53,$C$51lt;$C$52),5, 0))--
John James
------------------------------------------------------------------------
John James's Profile: www.excelforum.com/member.php...oamp;userid=32690
View this thread: www.excelforum.com/showthread...hreadid=531882try this

IF(A25gt;1,IF(AND($C$51gt;=$C$53,$C$51lt;$C$52),5,0),A25 )quot;ben simpsonquot; wrote:

gt; What would be the best way to combine the following two formulas?
gt; =IF($A$25=0,quot;quot;,$A$25) and =IF(AND($C$51gt;=$C$53,$C$51lt;$C$52),5,0)
gt;
gt; Meaning if cell A25 is blank then leave a blank in this cell, but if there
gt; is a value in A25 then perform the following formula.
gt;
gt; Thanks in advance for the help......Ben