i need help setting up a formula in excel

[Avril M.]

Can someone give me the formula for the following

Less than 80% then cell =A
80%-100% then cell = B
101% - 120% then cell = C
Above 120% then cell = D

 

[Guest]

Hi

Try this:
=IF(A2<0.8,"A",IF(A2>1.2,"D",IF(A2>1.01,"C","B")))

Andy.