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.

"Littlerose210" wrote in message
...
=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.