Posted to microsoft.public.excel.worksheet.functions

amandooshna amandooshna is offline

external usenet poster

Posts: 5

IF not working

=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)))))

This above sum works, execpt for the last IF function. For some reason my
result always comes out with a negative, when it should be 0. Any
suggestions on why? Or what I should do to change?

Thanks!

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
Sum(if not working	Beverly C	Excel Discussion (Misc queries)	5	February 6th 07 02:10 PM
SUM not working	scott	Excel Worksheet Functions	5	January 9th 07 05:18 PM
was working, now :(	Mark B	Excel Worksheet Functions	1	January 17th 06 02:40 AM
F4 Key not working....	Calvin	Excel Discussion (Misc queries)	2	July 29th 05 09:03 AM
Working out UK tax	hawkeye uk	New Users to Excel	6	March 11th 05 04:23 PM

All times are GMT +1. The time now is 09:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us