Posted to microsoft.public.excel.worksheet.functions

beyond22

external usenet poster

Posts: 2

Working with logical functions

I am Working with Excel 2003 using the IF operator where the correct result
appears but the value doesn't make sense to me. Using the following:
=IF(C9<F9,"0",C9-F9) where C9 is 600,000 and F9 is the product of
10,000,000*.07 which is 700,000 the result is correctly the number zero (0).

The trouble is if I attempt to use that cell for additional calculations the
value (0) is greater than any positive number. What am I missing?

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
Date Functions in Excel	Paul	Excel Worksheet Functions	1	May 8th 06 01:57 AM
working with time functions	Chris01623	Excel Discussion (Misc queries)	3	August 25th 05 01:37 PM
Visible rows and functions that work	tracy	Excel Worksheet Functions	2	August 19th 05 05:25 AM
logical functions	wiz546	Excel Worksheet Functions	1	February 1st 05 09:42 AM
logical functions	wiz546	Excel Worksheet Functions	1	February 1st 05 03:02 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us