Help with IF Functions
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 |
Help with IF Functions
=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 |
Help with IF Functions
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 |
Help with IF Functions
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 |
Help with IF Functions
=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 |
All times are GMT +1. The time now is 05:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com