P
Princessl210
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(j3>0,IF(H3=0,IF(j3>0,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.
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(j3>0,IF(H3=0,IF(j3>0,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.