Menu

commission calculation

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.worksheet.functions

LMM300M

LMM300M is offline

external usenet poster

Posts: 2

Default

commission calculation

can you send me a copy of your sheet? Thanks LMM

"Rick" wrote:

I have a spreadsheet set up that calculates my total production volume and is
entered in a cell for Totals. I want to take that total number and calculate
commissions using the following formula:
if volume 0-500000, multiply by .0045
if 500001-750000, multiply by .0050
if 750001-1250000, multiply by .0055
if 1250001-2000000, multiply by .0060
if 2000000 and above, multiply by .0065

and return the answer to the cell labeled "Commission"
--
Rick

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
NEED HELP! Commission calculation	Wannano	Excel Discussion (Misc queries)	4	March 13th 07 09:50 PM
How do I set up a commission calculation chart w/ "if" condition?	Johnw	Excel Worksheet Functions	2	March 10th 06 02:58 AM
Sales V Commission updated calculation	Carauto	Excel Discussion (Misc queries)	5	December 9th 05 03:11 PM
Commission Calculation	nospaminlich	Excel Worksheet Functions	8	November 1st 05 02:47 PM
Commission Calculation with IF Stmt.	Shams	Excel Worksheet Functions	2	August 10th 05 05:06 PM

All times are GMT +1. The time now is 06:31 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement