Help with IF Functions

J

jclark

Hello,
I'm looking for some help with If functions and displaying different text
when the results are with in a range. What would a formula look like in col
D

A B C D
r1 1 6 (a1+b1) 7 better
r2 20 5 (a2+b2) 25 awsome
r3 0 1 (a3+b3) 1 Good

range is 1-5=Good;6-11=better;12-20=best;21-25=awsome

Thanks,
Hope this was clear enough
Jim C
 
B

Bernard Liengme

Try
=IF(C1<6,"Good",IF(C1<12,"Better",IF(C1<21,"Best","Awesome")))

This looks so much like a homework assignment! You should try to make an
alternative formula that begins
=IF(C1>20.......
best wishes
 
P

Pete_UK

Put this formula in D1:

=IF(C1>=21,"awesome",IF(C1>=12,"best",IF(C1>=6,"better","Good")))

Copy it down as far as required.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top