If/then formulas

[akerney]

I have a worksheet that has a formula for one of the cells (=SUM(J5*F5)-G5).
Now I need to put an if/then formula into that particular formula. When I use
the formula above, the answers sometimes come out negative (which is normal)
but I need it to be programmed where, if the answer comes out negative, then
it should automatically be adjusted to $0. How do I add and if/then formula
to a formula already given??

 

[FSt1]

hi
=IF(SUM(J5*F5)-G5<0,0,SUM(J5*F5)-G5)


Regards
FSt1

 

[Niek Otten]

First, you don't need the SUM part;
This will do:
=(J5*F5)-G5

New formula:
=MAX((J5*F5)-G5),0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I have a worksheet that has a formula for one of the cells (=SUM(J5*F5)-G5).
| Now I need to put an if/then formula into that particular formula. When I use
| the formula above, the answers sometimes come out negative (which is normal)
| but I need it to be programmed where, if the answer comes out negative, then
| it should automatically be adjusted to $0. How do I add and if/then formula
| to a formula already given??

 

[Sandy Mann]

Try:

=MAX(J5*F5-G5,0)
Note that the neither the SUM() not the parenthesis around J5*F5 are
required because in XL multiplication takes precedence over subtraction.


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk