Thread
:
If/then formulas
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
If/then formulas
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
Replace @mailinator.com with @tiscali.co.uk
"akerney" wrote in message
...
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??
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann