Posted to microsoft.public.excel.worksheet.functions

cmac

external usenet poster

Posts: 16

mutiple if statements that then compute a value

I am trying to put together a sales commission formula that pays out at each
different levels depending on the sales value. But, I can't seem to get it
to total correctly. Any suggestions?

fees payout percentage
0-15000 15%
15001-30000 14%
30001-50000 13%
50001-75000 12%
75001 and greater 11%

Thanks for any help

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
auto compute	Joseph	Excel Worksheet Functions	1	January 5th 08 06:39 AM
formulas will not compute	phil	Excel Worksheet Functions	2	November 20th 06 02:08 PM
compute a percentage	Jeanie	New Users to Excel	2	May 25th 06 07:36 PM
Formulas that don't compute	Paulymon	Excel Worksheet Functions	3	January 31st 06 02:10 AM
mutiple regression help	happycow	Excel Discussion (Misc queries)	1	July 30th 05 04:47 AM

All times are GMT +1. The time now is 07:39 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us