software

My formula is IF(H27gt;0,H27,(M25 M26)*0.15). I want the test to include zero
in the true statement, but if I put gt;= it accepts blanks. How can I write
this?
=if(and(h27gt;=0,not(isblank(h27))),h27,(m25 m26)*0. 15)

quot;Nancyquot; wrote:

gt; My formula is IF(H27gt;0,H27,(M25 M26)*0.15). I want the test to include zero
gt; in the true statement, but if I put gt;= it accepts blanks. How can I write
gt; this?
gt;
gt;

Hi Nancy

The following formula seems to do the trick
=IF(OR(AND(H27lt;gt;quot;quot;,H27=0),H27gt;0),H27,(M25 M26)*0.1 5)
hth

quot;Nancyquot; wrote:

gt; My formula is IF(H27gt;0,H27,(M25 M26)*0.15). I want the test to include zero
gt; in the true statement, but if I put gt;= it accepts blanks. How can I write
gt; this?
gt;
gt;


If H27 cannot be negative

=IF(H27=quot;quot;,(M25 M26)*0.15,H27)

or if it can

=IF(OR(H27=quot;quot;,H27lt;0),(M25 M26)*0.15,H27)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=514498AWESOME!!!! Thank you.

quot;bpeltzerquot; wrote:

gt; =if(and(h27gt;=0,not(isblank(h27))),h27,(m25 m26)*0. 15)
gt;
gt; quot;Nancyquot; wrote:
gt;
gt; gt; My formula is IF(H27gt;0,H27,(M25 M26)*0.15). I want the test to include zero
gt; gt; in the true statement, but if I put gt;= it accepts blanks. How can I write
gt; gt; this?
gt; gt;
gt; gt;