Need Formula Help!

[Mitzy]

On the spreadsheet I've been working on, I had the following formula i
cell D27:

=D25+(D21+D23)

Now my boss wants that result to default to 0 if the number in D27 is
negative number. I'm not sure what the formula should be now. I di
do the following in cell D28:

=IF(D27<=0,0)

When D27 is a positive number, FALSE appears in D28. But, I want 0 t
appear in D27 when the original total is a negative number and not hav
the FALSE appear; otherwise I want the first formula of =D25+(D21+D23
to regenerate when the number is positive.

Hope this makes sense and someone can assist me

 

[Frank Kabel]

Hi
try in D27:
=MAX(D25+D21+D23,0)

 

[JBoulton]

Mitzy,

This should do it for you.

=IF(D27<=0,0,D25+(D21+D23))

Ji

 

[Alan]

If I understand correctly try
=IF(D25+(D21+D23)<0,0,D25+(D21+D23))
Regards,

 

[Mitzy]

Thanks guys! You are all the Best!!!
Alan & Frank's formula worked, but JBoulton's did not.

I really appreciate this excel help forum!!

 

[HGood]

This seems to work in D27:
=IF(D25+(D21+D23)<0,0,D25+(D21+D23))
Harold