G
Guest
Hi All,
I need some help with mulitple condtion using if and else if(If possible)
otherwise I am open for better ideas.
I have 2 columns A & B (These number are just estimated points it will be
changed)
Column A Column B
< 70 5 Points
70-80 15 Points
80-85 14 Points
85-90 13 Points
90-95 12 Points
95-100 12 Points
100 10 Points
100-110 8 Points
110-120 7 Points
I hope I am not asking that cannot be done
Please if someone can help.
Thanks in Advance
AM
I need some help with mulitple condtion using if and else if(If possible)
otherwise I am open for better ideas.
I have 2 columns A & B (These number are just estimated points it will be
changed)
Column A Column B
< 70 5 Points
70-80 15 Points
80-85 14 Points
85-90 13 Points
90-95 12 Points
95-100 12 Points
100 10 Points
100-110 8 Points
110-120 7 Points
Based on Column A, I want the formula in Column B to generate the points.120 5 Points
I hope I am not asking that cannot be done
Please if someone can help.
Thanks in Advance
AM