Forum Discussion
Solved
Nested Formula
Good day I need help pleas IF(M4>80,"7",(M4>70,"6",(M4>60,"5")))
Place the numbers in a two-column table, similar to this:
A B 1 60 5 2 70 6 3 80 7
And use a formula like this:
=VLOOKUP(M4,$A$1:$B$3,2,TRUE)
Place the numbers in a two-column table, similar to this:
A B
1 60 5
2 70 6
3 80 7
And use a formula like this:
=VLOOKUP(M4,$A$1:$B$3,2,TRUE)
Thank you for your reply, I got it to work as per your directions, however some fields give me a #N/A value why is this as the array table does have the values it should.
- The table must be sorted in ascending order of the first column