Integer to a few specific lookup values

[danseq]

Hi, beginner here.

In G26 I want to input an integer value from 1 to 5, or beyond.

In H26 I want to have a formula which gives the following:

If G26=1, then H26=15%
If G26=2, then H26=12.5%
If G26=3, then H26=10%
If G26=4, then H26=7.5%
If G26=5, then H26=5%

If G26>5, then H26=5%

If G26=(no data, blank), then H26=0%

How do I structure this formula? If possible I would rather store these values in the formula (H26) and not have to put them somewhere else in the spreadsheet, but any solution is better than none.

Thank you!

-Dan

[mikerickson]

How about =CHOOSE(MAX(G26,6)+1, 0, .15, .125, .1, .75, .05, .05)

[danseq]

Brilliant! Thank you...that gets me on the right track!