Nested IF function

[Littlerose210]

I am supposed to enter a formula for 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 appreciate it.

Here is the info:

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 here:

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).

If this makes sense to anyone I really would appreciate the help...

 

[BoniM]

Post the formulas that didn't work for you so we can help you figure out
where you went wrong...

 

[Littlerose210]

=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.

 

[Fred Smith]

First, lose the quotes. They specify text, and you need numbers for
percentages.
Second, you need to compare a cell to the numbers. So, if the current weeks
of supply is in H3, put that in the IF statement.

So you want something like:

=if(h3<=8,0,if(h3<=14,0.15,if(h3<=18,0.25,0.40)))
Format as percentage.

See if that works for you.

Regards,
Fred.