Workaround to giant nested if statement for invoice value increments

[Miskondukt]

Lo all, any ideas on how I might be able to get around writing a long, nested IF statement for less then greater then for this invoice increment table?

Increments.png

[JohnTopley]

Use a lookup table with VLOOKUP or INDEX match

see attached:

Value in C1 , result in D1

[Miskondukt]

Doh! facepalm morning. Thank you

[JohnTopley]

You are very welcome: thanks for feedback and rep.