Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 29th 04, 12:54 AM
babydear12
 
Posts: n/a
Default 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   Report Post  
Old October 29th 04, 12:59 AM
Steve H.
 
Posts: n/a
Default

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   Report Post  
Old October 29th 04, 01:00 AM
Steve H.
 
Posts: n/a
Default

=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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I create a formula to seperate name into two cells (last, . jobby55 Excel Discussion (Misc queries) 2 January 13th 05 05:00 AM
how can i create a formula or format the cells so the answer is a. jenniss Excel Discussion (Misc queries) 5 January 6th 05 04:50 PM
create a chart with a formula anon Charts and Charting in Excel 1 December 15th 04 08:55 PM
How can I create formula that turns a date into the week # in don Excel Discussion (Misc queries) 0 November 28th 04 09:21 PM
Please help create a formula JuliaC Excel Worksheet Functions 3 October 27th 04 11:12 PM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017