Posted to microsoft.public.excel.worksheet.functions

Teethless mama Teethless mama is offline

external usenet poster

Posts: 3,718

IF Function - Calculation not working

=IF(C7<=2000,0,IF(C7<=6000,(C7-2000)*10%,IF(AND(C7<=10000,B76000),6000*10%+(C7-6000)*15%,6000*10%+4000*15%+(C7-10000)*20%)))

"amandooshna" wrote:

I have sum:

=IF(C7=10000,SUM(6000*10%)+(4000*15%)+((C7-10000)*20%),IF(C7<=10000,IF(B76000,SUM(6000*10%)+ ((C7-6000)*15%),IF(C7<=6000,SUM((C7-2000)*10%),IF(C7<=2000,0)))))

And this works, however when I change one of the input figures, then the
total comes our wrong.
my calculation is based on 10% from $2m - $6m, 15% from $6m-$10m and 20%
$10m and above.

Have I got my sum wrong?

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
NetWorkdays Calculation isn't working	undrline via OfficeKB.com	Excel Worksheet Functions	6	January 11th 07 09:51 PM
Workday calculation - not working	LOK	Excel Worksheet Functions	5	July 18th 06 11:31 PM
Calculation not working	Copper via OfficeKB.com	New Users to Excel	4	February 22nd 06 09:11 PM
Auto Calculation not working	vinnie31	Excel Worksheet Functions	1	January 10th 06 10:43 PM
Automatic calculation is not working	susang	Excel Discussion (Misc queries)	4	November 4th 05 03:51 PM

All times are GMT +1. The time now is 10:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us