Need Formula Help!

  • Thread starter Thread starter Mitzy
  • Start date Start date
M

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
 
Thanks guys! You are all the Best!!!
Alan & Frank's formula worked, but JBoulton's did not.

I really appreciate this excel help forum!!
 
Back
Top