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 cell display formula vba Excel change range font formatting if cell equals Excel count if one value is less than another total Excel data validation list and "if" formula Excel formula if a1 value matches list then Excel if greater than or less than zero rank Excel sum if real number Excel vba if a = b then run Excel: check if part of two cells matches specific text Excel: if then with wild card Format row in excel 07 and change colour of line if yes Formula excel sum if duplicate How to add 1 to value in excel if statement If a1 a2 is less than 1 excel formula Month of supply formula excel Ms excel calendar date formula Nested if coding excel 2007 Write a formula in excel to match a to b to c