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

=if(and(h27>=0,not(isblank(h27))),h27,(m25+m26)*0.15)

"Nancy" wrote:

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

Hi Nancy

The following formula seems to do the trick
=IF(OR(AND(H27<>"",H27=0),H27>0),H27,(M25+M26)*0.15)
hth

"Nancy" wrote:

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

If H27 cannot be negative

=IF(H27="",(M25+M26)*0.15,H27)

or if it can

=IF(OR(H27="",H27<0),(M25+M26)*0.15,H27)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=514498

AWESOME!!!! Thank you.

"bpeltzer" wrote:

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