| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to multiply data by one cell, based on data of another
hello,
I'm trying to calculate commission bonuses based on gross sales by multipling a percentage by the net sales. Example: A1= Gross Sales A2= Net sales A3= Bonus Commission. Here's the formula I tried, but it's only working for half the equation: =IF(A1=6000,A2*.225,IF(A1=8000,A2*.25)) The formula works only for the first command (*.225). When I enter 8000 in the A1 cell, it still (*.225), instead of (*.25). Any suggestions would be helpful. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to multiply data by one cell, based on data of another
I think you need the and command - I assumed taht you were searching for the
gross Sales in column A and column B was net sales? =IF(AND(A1=60000,A1<80000),B1*0.25,IF(A1=80000,B 1*0.25,0)) "ADC76" wrote: hello, I'm trying to calculate commission bonuses based on gross sales by multipling a percentage by the net sales. Example: A1= Gross Sales A2= Net sales A3= Bonus Commission. Here's the formula I tried, but it's only working for half the equation: =IF(A1=6000,A2*.225,IF(A1=8000,A2*.25)) The formula works only for the first command (*.225). When I enter 8000 in the A1 cell, it still (*.225), instead of (*.25). Any suggestions would be helpful. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to multiply data by one cell, based on data of another
It looks to me like you just need to test for 8000 first, not 6000. If
A18000 it's also greater than 6000 so the test in the first IF is satisfied. I'd say try: =IF(A1=8000,A2*.25,IF(A1=6000,A2*.225)) Will "ADC76" wrote: hello, I'm trying to calculate commission bonuses based on gross sales by multipling a percentage by the net sales. Example: A1= Gross Sales A2= Net sales A3= Bonus Commission. Here's the formula I tried, but it's only working for half the equation: =IF(A1=6000,A2*.225,IF(A1=8000,A2*.25)) The formula works only for the first command (*.225). When I enter 8000 in the A1 cell, it still (*.225), instead of (*.25). Any suggestions would be helpful. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to multiply data by one cell, based on data of another
Thanks Don! It works great now! Never would have thought to use AND.
I appreciate the quick response too! ADC76 "ADC76" wrote: hello, I'm trying to calculate commission bonuses based on gross sales by multipling a percentage by the net sales. Example: A1= Gross Sales A2= Net sales A3= Bonus Commission. Here's the formula I tried, but it's only working for half the equation: =IF(A1=6000,A2*.225,IF(A1=8000,A2*.25)) The formula works only for the first command (*.225). When I enter 8000 in the A1 cell, it still (*.225), instead of (*.25). Any suggestions would be helpful. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiply data in every 3rd row on a sheet | Excel Worksheet Functions | |||
| Changing Cell Background Color based on data from another cell | Excel Discussion (Misc queries) | |||
| How to cross-multiply text data in excel?? | Excel Discussion (Misc queries) | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
Hybrid Mode
