This one is really twisting my noodle... I have 4 nested IF statements that I need to combine into one statement (the parameter choices result in quantities) The proprietary ERP solution into which I need to place this nested IF does not allow AND, OR, etc. Below are the 4 statements and each works 'stand alone' as defined. Essentially I need to make it all the way to the end of the finished statement with the last resolving ZERO. Parameters
For C1 are either 1 or 2
For C2 are 1,2 or 3 (NOTE: parameters 2 and 3 result in the same quantity, hence C2>1 in the formula)
For C3 there are 25 acceptable entries numbers 1 through 25 (NOTE: there are ranges within the last statement of C3)
I've been unable to determine the exact format, bracketing and resolving for Zero. Any help or directions to a tutorial of nested IF WITHOUT the use of AND, OR, NOT, ELSE would be appreciated!