Attached is a sample worksheet. I need a method that can help me choose between multiplication and addition (i.e. x*(1+2%) or x+0.5, but the 2% and 0.5 would be in the same cell and would otherwise be dependent on a different formula acting as a switch). Any ideas would be greatly appreciated, I have already attempted to use the "Choose" function as you can see in the sample.
What did you try?
Thanks, I would do that, but it defeats the purpose of using choose. The sample worksheet assumes that H5 is a simple plugged number. In the actual spreadsheet it's a long formula that I'd rather not have to repeat in order to achieve two different results based on a switch...
Maybe use the escalation 1 or 2 for the switch between formulas in If statement
Thanks Pike, I appreciate your efforts, but that’s not the solution I’m looking for. The non-sample formula currently reads: =if(h4=%,five-line-formula-that-results-in-$1000,000*(1+H15),five-line-formula-that-results-in-$1000,000+(H15*squarefeet)).
ideally,I wouldn’t have to repeat the five line formula if the false position.
You can have the long formula in another cell (which is perfectly OK) or use named formula