Marcos Lee
New Member
Has anyone any idea why this formula doesn't work!?
=IF(B4>89,E7,IF(B4<=89,E6,IF(B4<=79,E5)))
It looks at a value in B4 and then should represent what level the score is. from this table.
Level Score
0 69-0
1 79-70
2 89-80
3 90+
Any help appreciated!!
=IF(B4>89,E7,IF(B4<=89,E6,IF(B4<=79,E5)))
It looks at a value in B4 and then should represent what level the score is. from this table.
Level Score
0 69-0
1 79-70
2 89-80
3 90+
Any help appreciated!!