i need help setting up a formula in excel
 

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

i need help setting up a formula in excel
 

Hi

Try this:
=IF(A2<0.8,"A",IF(A21.2,"D",IF(A21.01,"C","B")))

Andy.

"Avril M." wrote in message
...
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