What if Analysis

[Coreen Gibson]

if 1-20 = 1,21-40=2 41-70=4 71-100=4 and thereafter 1 for every 50 what what if analysis formula should I use

[#2]

Try using the Vlookup Function along with a lookup table (See attached .xlsx):

[#3]

Will give it a try.

Thanks