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

--
Allllen


"ianonline" wrote:


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