Nested Formula

New Contributor

Good day

I need help pleas



4 Replies
best response confirmed by allyreckerman (Microsoft)

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:

@MarleneCunliff As a variant, and if you insist on using nested IF's, perhaps this is what you tried to achieve:


where "x" will be returned for any value in M4 less than or equal to 60. Remove the ,"x" part and it will return FALSE in such case.

@Jan Karel Pieterse 

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