Nested IF with a possible SUM?
 

type the nested IF function into cell I3 to calculate the new price. the
goals of this worksheet is to allow the price change manager to override this
calculation by entering a new price into one of the cells column J. This IF
function will see whether the price entered into column J is greater than 0.
if it is, that number will become the new price. if the value in column J is
less than or equal to 0, the nested IF function will calculate the new price
based on the suggested markdown. the logical tests and outputs for this
nested IF function are as follows. be sure to enter each logical test in the
sequence listed.

a. if J3 0, the output of the function should be the value in cell J3. if
J3 is greater than 0, the pricing manager has manually set a new price for
this item.
b. if H3 = 0, the output of the function should be cell C3. if H3 is 0, then
there is no suggested markdown. the output of the function should be whatever
the current prices is in cell C3.
c. if both logical tests (J3 0 and H3 = 0) are false, then the function
should calculate the new price using the formula C3 - (C3 * H3).

This is what I figured so far... But its not working I'm not sure why.

=IF(j30,IF(H3=0,IF(j30,h3=0,"false",if(sum(c3-(c3*h3))))))

Sorry I just don't understand the IF functions even when I read through the
random online helps that don't apply to this equation.

Thank you so much.

Nested IF with a possible SUM?
 

Please don't continually start new threads. Stick to your original thread,
and if you need to continue the discussion, do it there. [And changing
names doesn't help, either.]
--
David Biddulph

"Princessl210" wrote in message
...
type the nested IF function into cell I3 to calculate the new price. the
goals of this worksheet is to allow the price change manager to override
this
calculation by entering a new price into one of the cells column J. This
IF
function will see whether the price entered into column J is greater than
0.
if it is, that number will become the new price. if the value in column J
is
less than or equal to 0, the nested IF function will calculate the new
price
based on the suggested markdown. the logical tests and outputs for this
nested IF function are as follows. be sure to enter each logical test in
the
sequence listed.

a. if J3 0, the output of the function should be the value in cell J3.
if
J3 is greater than 0, the pricing manager has manually set a new price for
this item.
b. if H3 = 0, the output of the function should be cell C3. if H3 is 0,
then
there is no suggested markdown. the output of the function should be
whatever
the current prices is in cell C3.
c. if both logical tests (J3 0 and H3 = 0) are false, then the function
should calculate the new price using the formula C3 - (C3 * H3).

This is what I figured so far... But its not working I'm not sure why.

=IF(j30,IF(H3=0,IF(j30,h3=0,"false",if(sum(c3-(c3*h3))))))

Sorry I just don't understand the IF functions even when I read through
the
random online helps that don't apply to this equation.

Thank you so much.