Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a formula that will multiply a 5% of a value >$150
Here is my dilema. I have to creat formula's to multiply 40% of total sales,
they also get a bonus of 5% for everything over $1500 in total sales. They also receive another 5% bonus if there retail sales are 30% of there total sales. I also have to create a quarterly bonus of 12% of there total retail sales over $100. I have been trying to create formulas to do these calculations for me and I am having no luck. I am using Excel 2000. |
#2
|
|||
|
|||
If your value is in C! use this =IF(C11500,(C1-150)*5%,"")
"babydear12" wrote in message ... Here is my dilema. I have to creat formula's to multiply 40% of total sales, they also get a bonus of 5% for everything over $1500 in total sales. They also receive another 5% bonus if there retail sales are 30% of there total sales. I also have to create a quarterly bonus of 12% of there total retail sales over $100. I have been trying to create formulas to do these calculations for me and I am having no luck. I am using Excel 2000. |
#3
|
|||
|
|||
=IF(C11500,(C1-1500)*5%,"")
Left off a 0. "babydear12" wrote in message ... Here is my dilema. I have to creat formula's to multiply 40% of total sales, they also get a bonus of 5% for everything over $1500 in total sales. They also receive another 5% bonus if there retail sales are 30% of there total sales. I also have to create a quarterly bonus of 12% of there total retail sales over $100. I have been trying to create formulas to do these calculations for me and I am having no luck. I am using Excel 2000. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I create a formula to seperate name into two cells (last, . | Excel Discussion (Misc queries) | |||
how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) | |||
create a chart with a formula | Charts and Charting in Excel | |||
How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) | |||
Please help create a formula | Excel Worksheet Functions |