Is there a formula or vba that will take user input from a couple of cells and use a particular formula in another cell chosen based on the user input?
For example, if user enter Week # = 1, # of Days = 100, then Projected Month End needs to calculate 100/95. But if user enters Week # = 2, # of Days = 90, then the Projected Month End needs to calculate 90/80.
Week # # of Days
Projected Month End