| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
