Forum Discussion
What if Analysis
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
Try using the Vlookup Function along with a lookup table (See attached .xlsx):
Will give it a try.
Thanks
