Forum Discussion
Nested If formula
Dears ... Kindly , need help with a complected nested IF formula to calculate commission as follows :- Daily , weekly , monthly basis 4 categories 5 to 6 parameters for each category Ea...
My two cents.
The solution would probably end in having a helper table (or even more) and lookup functions or SUMIFS() to get the results.
For such cases I keep SUMPRODUCT() in mind, but doesn't matter - yes, most probably not IFS or like.