Posted to microsoft.public.excel.charting

H4X3R

external usenet poster

Posts: 3

Bug with advanced if statment?

Hello im using the follow if statment

=IF(C21250,C21*15%,IF(C21=500,C21*25%,IF(C21=10 00,C21*50%,"NO")))

it works fine but when it comes accross a number "1000" it doesnt times it
by 50% for e.g 1000*50% is ment to be 500 the if statment gives me 150 anyone
help 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
Blanks and Advanced Filters	Janie	Excel Discussion (Misc queries)	7	August 24th 06 06:31 PM
Advanced filter	Daisy10	Excel Worksheet Functions	1	August 2nd 06 02:38 AM
Advanced Filter not working	babypenquin	Excel Worksheet Functions	1	June 22nd 06 05:48 PM
Advanced filtering on text and blanks	dtencza	Excel Discussion (Misc queries)	4	March 14th 06 01:07 AM
advanced IF statment	tom	Excel Discussion (Misc queries)	1	November 18th 05 07:46 AM

All times are GMT +1. The time now is 04:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us