Forum Discussion
Advice Needed: Performing complicated nested if calculation
Hi there, I am trying to find a way to automatically calculate a sum, based on a number of variables. I can't figure out whether an extremely long series of nested Ifs in a Formula, or a VBA functio...
Consider not using just one cell and put all of your formula in that one, perhaps use several cells with the different parts and then evaluate on those. At least do that when you build the formula and troubleshoot.
Also consider using the Ifs() formula instead.