formula - Output value based on number range entered in excel -


i need find formula can use number, , have output number identified correspond range.

for instance, need able input:

a number >2.50 , <7.49, , formula spit out $0.05

a number >7.50 , <24.49, , formula spit out $0.10

a number >25.00 , <74.99 , formula spit out $0.50, , on/so forth.

if want have set of pre-defined values output showed in example use =vlookup() this:

enter image description here

using can set desired output in table. cannot tell if there pre-defined pattern using determine outputs, if simple math algorithm might make more sense this.


Comments