Bill R

Posts: n/a

First part of "IF" function returns false even if true. ??

=IF((O12=12/31/2005),(IF(ISERROR(SUM(((F32)/(DAYS360(DATE(2004,12,31),X1,FALSE)))*(360))*(F13) ),"",(SUM(((F32)/(DAYS360(DATE(2004,12,31),X1,FALSE)))*(360))*(F13) ))),F12)

The first part of the formula, (O12=12/31/2005), returns false even if it's
true. The rest of the formula works great.

Any suggestions?

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
IF is not carrying out the FALSE part	derekbrown	Excel Worksheet Functions	3	August 23rd 05 11:28 AM
A function that returns the name of the current cell	yarp	Excel Discussion (Misc queries)	17	August 9th 05 09:44 AM
Date & Time	mully	New Users to Excel	4	May 23rd 05 11:56 AM
Grouped Sheets and Formating	Pank Mehta	Excel Discussion (Misc queries)	3	March 24th 05 01:42 AM
Grand Totals @ Same Place	Amber M	Excel Worksheet Functions	2	December 30th 04 07:13 PM

All times are GMT +1. The time now is 07:20 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us