Hello,

I'm trying to get a formula I produced to work. I wanted cells added
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,"Very
Good",IF(L1+(L2*3)<6,"Good",IF(L1+(L2*3)<8,"Averag e",IF(L1+(L2*3)<11,"Below
Average",IF(L1+(L2*3)<13,"Poor",IF(L1+(L2*3)<15,"T errible","Terrible")))))))

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

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

Thanks for your help.

Ian


--
ianonline
------------------------------------------------------------------------
ianonline's Profile: http://www.excelforum.com/member.php...o&userid=34279
View this thread: http://www.excelforum.com/showthread...hreadid=553267