Why doesn't writing a nested IF function work?
 

I am supposed to enter a formula in my excel document that includes a nested
IF function. But the info they provided makes it pull up an error no matter
how I enter it. There are two questions I'm having this issue with... If
anyone can help I'd really appreciate it.

Here is the info I'm supposed to enter. (I've included the two options I
thought were closest to the formula below):

Enter a nested IF function in cell H3 that will calculate the suggested
markdown. this type of calculation could be used buy a company that sets
target weeks of supply for the items it sells. if the weeks of supply get to
high, the company may reduce, or mark down, the price to increase sales. use
the following criteria when creating the function. also, make sure each
logical test is entered into the function in the order listed he

a. if the current weeks of supply <=8, the suggested markdown should be 0.
b. if the current weeks of supply <=14, the suggested markdown should be .15.
c. if the current weeks of supply <=18, the suggested markdown should be .25.
d. if the current weeks of supply is greater than 18 (or not less than or
equal to 18), the markdown should be .40.



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 have tried so far...


=if(<=8,"0",<=14,".15",<=18,".25",18,".40")
=if(<=8,"0",<=14,15%",<=18,"25%",18"40%")

Assuming they are percentages because you can't use .15 in the formula.

And the other formula I have no idea even how to write it out. Nothing I
tried so far has worked. And no one seems to know how to figure these out.
I've never used excel before but I've been able to figure everything else out
through trial and error but these two questions I've been stuck for 3 days
on...

Why doesn't writing a nested IF function work?
 

Littlerose210 -

And no one seems to know how to figure these out. <

Browse to google.com, and search for "excel nested if" (without the quotes).

There are numerous links, many with step by step tutorials.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel



"Littlerose210" wrote in message
...
I am supposed to enter a formula in my excel document that includes a
nested
IF function. But the info they provided makes it pull up an error no
matter
how I enter it. There are two questions I'm having this issue with... If
anyone can help I'd really appreciate it.

Here is the info I'm supposed to enter. (I've included the two options I
thought were closest to the formula below):

Enter a nested IF function in cell H3 that will calculate the suggested
markdown. this type of calculation could be used buy a company that sets
target weeks of supply for the items it sells. if the weeks of supply get
to
high, the company may reduce, or mark down, the price to increase sales.
use
the following criteria when creating the function. also, make sure each
logical test is entered into the function in the order listed he

a. if the current weeks of supply <=8, the suggested markdown should be 0.
b. if the current weeks of supply <=14, the suggested markdown should be
.15.
c. if the current weeks of supply <=18, the suggested markdown should be
.25.
d. if the current weeks of supply is greater than 18 (or not less than or
equal to 18), the markdown should be .40.



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 have tried so far...


=if(<=8,"0",<=14,".15",<=18,".25",18,".40")
=if(<=8,"0",<=14,15%",<=18,"25%",18"40%")

Assuming they are percentages because you can't use .15 in the formula.

And the other formula I have no idea even how to write it out. Nothing I
tried so far has worked. And no one seems to know how to figure these out.
I've never used excel before but I've been able to figure everything else
out
through trial and error but these two questions I've been stuck for 3 days
on...