excelhelpseeker
New member
- Joined
- Jan 7, 2015
- Messages
- 29
- Reaction score
- 0
- Points
- 0
Hi Champs,
I have A1 and B1
i need to display grades in B1 according to the value in A1.
if A1 is between 0 and 0.99, B1 should display A
if A1 is between 1 and 2.49, B1 should display B
if A1 is between 2.50 and 3.49, B1 should display C
if A1 is between 3.50 and 3.89, B1 should display D
if A1 is between 3.99 and 4.19, B1 should display E
if A1 is between 4.2 and 5.00, B1 should display F
if A1 is between 5.1 and 6.00, B1 should display G
please help me with a formula
I have A1 and B1
i need to display grades in B1 according to the value in A1.
if A1 is between 0 and 0.99, B1 should display A
if A1 is between 1 and 2.49, B1 should display B
if A1 is between 2.50 and 3.49, B1 should display C
if A1 is between 3.50 and 3.89, B1 should display D
if A1 is between 3.99 and 4.19, B1 should display E
if A1 is between 4.2 and 5.00, B1 should display F
if A1 is between 5.1 and 6.00, B1 should display G
please help me with a formula