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
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