IF Formula Error

  • Thread starter Thread starter Teri
  • Start date Start date
T

Teri

I have a spreadsheet that calculates a 3 year percentage ratio in colum F8.
I'm trying to create a formula that will look at the percentage ratio in a
cell and return the following information:

If over 125% "Surcharge" to appear in adjacent cell
If under 75% "Reduction to appear in adjacent cell
If between 76% and 124% "No Change" to appear in adjacent cell

Any help would be greatly appreciated!!

Thanks
 
Teri,

You may want to adjust the <= to get the precise boundaries you require

=IF(E8<=75%,"Reduction",IF(E8<125%,"No Change","Surcharge"))

Mike
 
THANK YOU SO MUCH!!! It worked perfectly!!

Mike H said:
Teri,

You may want to adjust the <= to get the precise boundaries you require

=IF(E8<=75%,"Reduction",IF(E8<125%,"No Change","Surcharge"))

Mike
Click to expand...
 
Back
Top