IF Formula help

  • Thread starter Thread starter ianonline
  • Start date Start date
I

ianonline

Hello,

I'm trying to get a formula I produced to work. I wanted cells adde
together and resulting amount to give a chosen word.

At the moment it is:
=IF(L1+(L2*3)<3,"Excellent",IF(L1+(L2*5)<4,"Ver
Good",IF(L1+(L2*3)<6,"Good",IF(L1+(L2*3)<8,"Average",IF(L1+(L2*3)<11,"Belo
Average",IF(L1+(L2*3)<13,"Poor",IF(L1+(L2*3)<15,"Terrible","Terrible")))))))

This works, but I want to simplify it. One of the cells has since bee
set to multiply by 3, so each (L1+(L2*3) can be (L1+L2), but tha
doesn't work! BY the way, the space in "terrible" is not there when
enter this message.

Does anyone know why? I would be happy to pay a small fee to get thi
one right if I can, or recommend your services.

Thanks for your help.

Ia
 
don't let anyone charge you for some help like this.

try

=IF(L1+L2<3,"Excellent",IF(L1+L2<4,"Very
Good",IF(L1+L2<6,"Good",IF(L1+L2<8,"Average",IF(L1+L2<11,"Below
Average",IF(L1+L2<13,"Poor",IF(L1+L2<15,"Terrible","Terrible")))))))

This works fine on my PC.

If it doesn't give you what you need, tell us what result you get and why it
doesn't match what you need to have.

Note: Your entry for 'Very good' has L1+(L2*5) rather than L1+(L2*3).
 
Back
Top