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

=LOOKUP(C1,{1,6,12,21},{"Good","Better","Best","Aw esome"})

copy down

"jclark" wrote:

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

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(C120.......
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jclark" wrote in message
...
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

Put this formula in D1:

=IF(C1=21,"awesome",IF(C1=12,"best",IF(C1=6,"be tter","Good")))

Copy it down as far as required.

Hope this helps.

Pete

On Oct 21, 3:55*pm, jclark wrote:
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

=CHOOSE(MATCH(C1,{1,6,12,21}),"Good","Better","Bes t","Awsome")


"jclark" wrote:

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