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