If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
nested functions
I am trying to create a nested function that returns a
value of a bonus figure paid at 5% over a certain amount e.g .total sales over 2000 and 2% at a lower amount e.g .total sales over 1500 and no bonus at a lesser amount (1200) I have used the if function but when calculated the cel shows the formula as opposed to the actual figure..I simply can not figure it out and it is driving me nuts!!!! |
#2
|
|||
|
|||
nested functions
Linda
I've tried this formula to work out the bonus: =IF(D182000,(D18-2000)*0.05,IF(D181500,(D18-1500)*0.02,"")) and it works OK. Make sure you have Calculation set to automatic and that in Tools/Options/View the Formulas option is not ticked. Andy. "Linda" wrote in message ... I am trying to create a nested function that returns a value of a bonus figure paid at 5% over a certain amount e.g .total sales over 2000 and 2% at a lower amount e.g .total sales over 1500 and no bonus at a lesser amount (1200) I have used the if function but when calculated the cel shows the formula as opposed to the actual figure..I simply can not figure it out and it is driving me nuts!!!! |
#3
|
|||
|
|||
nested functions
This formula will calculate the Bonus on the sales value
as well. =IF(C7=2000,C7*0.05,IF(AND(C7=1500,C72000),C7*0 .02,IF (C71500,C7*0,))) Hope it helps -----Original Message----- I am trying to create a nested function that returns a value of a bonus figure paid at 5% over a certain amount e.g .total sales over 2000 and 2% at a lower amount e.g .total sales over 1500 and no bonus at a lesser amount (1200) I have used the if function but when calculated the cel shows the formula as opposed to the actual figure..I simply can not figure it out and it is driving me nuts!!!! . |
Thread Tools | |
Display Modes | |
|
|