Thread: First part of "IF" function returns false even if true. ??
View Single Post
  #1   Report Post  
Bill R
 
Posts: n/a
Default 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 QuoteReply With Quote