Forum Discussion
Coreen Gibson
May 30, 2018Copper Contributor
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
- Matt MickleBronze Contributor
Try using the Vlookup Function along with a lookup table (See attached .xlsx):
- Coreen GibsonCopper Contributor
Will give it a try.
Thanks