Forum Discussion
Nested If formula
But that is one formula in one cell. In sample it's only result is illustrated for different sales per cent.
You add helper range at any place of your workbook as here in B4:C9. Using it one formula calculates per cent of commission (or commission itself) based on per cent of sales.
Dear ...
how can i link the helper range to the cell of calculation and how to link the cell of calculation to cell where i will enter sales # ?
thanks in advance
Add helper range into the suitable place, take formula and instead of sample file references use work file ones. If you have sample file it'll be easier to explain.
Dear ...
Kindly find attached actual excel sheet , please , go to experimental Saleem's commission .
what i tried to do :-
- I added the range
- I highlighted the cells , yellow for entry , gold for calculation
thanks in advance
Thank you for the file. In it
- the only helper range you need is this one
- I'm not sure what do you enter in AM33 here
I assume per cent of sales (as an example 92%)
- also not sure what shall be returned into AM34, per cent of commission or commission itself. Assuming the latest and that full commission is on O33 (210 here), formula will be
=O33*IF(AM33>1,1+(AM33-1)*2,IF(AM33>95%,AM33,LOOKUP(AM33,$B$5:$B$9,$C$5:$C$9)))