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:
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
Post a Comment