Hello,
I've read some answers to similar questions, but not quite the same...
How can I have *certain* results of my nested "IF" formula display in a different cell than the cell that the nested IF formula resides in?
Here's my formula which currently works (residing in cell (E8), I just want it to be different:
=IF(AND(B8>500000,B12>40000),(C8*B8)+(C12*B12),IF(AND(B8>500000,B12<40000),3000,IF(B8<500000,
"None")))
This is a "Bonus" formula, where if sales of "X" (B8) are more than "$SalesTarget1" AND ALSO sales of "Y" (B12) are more than "$SalesTarget2", then SalesPerson gets a bonus of 1.5% (C8) of "X"TotalSales (B8) and 1% (C12) of "Y"TotalSales (B12).
I would like it if the SalesPerson meets the bonus criteria, that the result of 1.5% x "X"TotalSales would display in cell E10 (next to cell "Food Sales") and 1% x "Y"TotalSales would display in cell E11 (next to cell "Beverage Sales"
I tried changing the formula to ...........,(C8*B8=E10,C12*B12=E11),........... and some variations of this, but to no avail. If anyone knows how to do this, I will have great respect for your amazing EXCEL Prowess!
Thank you in advance for any help.
Configuration: Windows XP or Vista64 or 7x64 depending on where I am Office2007 Enterprise Chrome browser
Excel 2003 text formula Excel 2007 date formula is 0/a Excel cell shows formula instead of value Excel nested if's examples Excel only calculate formula if two values provide Excel vba change formula cell reference Excel vba if loop multiple columns Excel vba if then value Excel vba if week date How to use information on one sheet in excel in a formula on another If formula if cell less than value If formula in excel example using formatting colour Mac excel if formula Nested if else statement in excel vba Print page if formula Return the value if it doesnt match in excel using if formula Software for excel check if cell is empty Visual basic excel monitor if a cell change