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

Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)))),F12)

"RFJ" wrote:

> You're trying to compare a cell which is formatted as a date with a multiple
> division (12 divided by 31 divided by 2005) so it will never work
>
> A quick workaround is to put your date in another cell, say z99 and then
> change your formula to
>
> If((O12=Z99,true,false)
>
>
> "Bill R" <BillR@discussions.microsoft.com> wrote in message
> news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> > =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?
> >
>
>
>

Unless O12 = 0.0001930657227898, the comparison will always be false.

12 divided by 31 divided by 2005 = 0.000193...

You could force XL to parse as a date by enclosing "12/31/2005" in
quotes, or you could use the DATE function:

IF(O12=DATE(2005,12,31),....


In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
Bill R <BillR@discussions.microsoft.com> wrote:

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

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" <BillR@discussions.microsoft.com> wrote in message
news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> =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?
>

Works great! Thanks! One more question,please. When I copy the formula to
other cells the cell references that refer to dates are not correct. How can
I fix it? I am pulling the dates from a list on the same sheet. Thanks again.

Here is the final working formula:
=IF((O12=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13)))),F12)

"JE McGimpsey" wrote:

> Unless O12 = 0.0001930657227898, the comparison will always be false.
>
> 12 divided by 31 divided by 2005 = 0.000193...
>
> You could force XL to parse as a date by enclosing "12/31/2005" in
> quotes, or you could use the DATE function:
>
> IF(O12=DATE(2005,12,31),....
>
>
> In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
> Bill R <BillR@discussions.microsoft.com> wrote:
>
> > =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?
>

Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)))),F12)

"RFJ" wrote:

> You're trying to compare a cell which is formatted as a date with a multiple
> division (12 divided by 31 divided by 2005) so it will never work
>
> A quick workaround is to put your date in another cell, say z99 and then
> change your formula to
>
> If((O12=Z99,true,false)
>
>
> "Bill R" <BillR@discussions.microsoft.com> wrote in message
> news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> > =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?
> >
>
>
>

Unless O12 = 0.0001930657227898, the comparison will always be false.

12 divided by 31 divided by 2005 = 0.000193...

You could force XL to parse as a date by enclosing "12/31/2005" in
quotes, or you could use the DATE function:

IF(O12=DATE(2005,12,31),....


In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
Bill R <BillR@discussions.microsoft.com> wrote:

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

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" <BillR@discussions.microsoft.com> wrote in message
news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> =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?
>

Works great! Thanks! One more question,please. When I copy the formula to
other cells the cell references that refer to dates are not correct. How can
I fix it? I am pulling the dates from a list on the same sheet. Thanks again.

Here is the final working formula:
=IF((O12=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13)))),F12)

"JE McGimpsey" wrote:

> Unless O12 = 0.0001930657227898, the comparison will always be false.
>
> 12 divided by 31 divided by 2005 = 0.000193...
>
> You could force XL to parse as a date by enclosing "12/31/2005" in
> quotes, or you could use the DATE function:
>
> IF(O12=DATE(2005,12,31),....
>
>
> In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
> Bill R <BillR@discussions.microsoft.com> wrote:
>
> > =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?
>

Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)))),F12)

"RFJ" wrote:

> You're trying to compare a cell which is formatted as a date with a multiple
> division (12 divided by 31 divided by 2005) so it will never work
>
> A quick workaround is to put your date in another cell, say z99 and then
> change your formula to
>
> If((O12=Z99,true,false)
>
>
> "Bill R" <BillR@discussions.microsoft.com> wrote in message
> news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> > =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?
> >
>
>
>

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" <BillR@discussions.microsoft.com> wrote in message
news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> =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?
>

Works great! Thanks! One more question,please. When I copy the formula to
other cells the cell references that refer to dates are not correct. How can
I fix it? I am pulling the dates from a list on the same sheet. Thanks again.

Here is the final working formula:
=IF((O12=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13)))),F12)

"JE McGimpsey" wrote:

> Unless O12 = 0.0001930657227898, the comparison will always be false.
>
> 12 divided by 31 divided by 2005 = 0.000193...
>
> You could force XL to parse as a date by enclosing "12/31/2005" in
> quotes, or you could use the DATE function:
>
> IF(O12=DATE(2005,12,31),....
>
>
> In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
> Bill R <BillR@discussions.microsoft.com> wrote:
>
> > =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?
>

Unless O12 = 0.0001930657227898, the comparison will always be false.

12 divided by 31 divided by 2005 = 0.000193...

You could force XL to parse as a date by enclosing "12/31/2005" in
quotes, or you could use the DATE function:

IF(O12=DATE(2005,12,31),....


In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
Bill R <BillR@discussions.microsoft.com> wrote:

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

Works great! Thanks! One more question,please. When I copy the formula to
other cells the cell references that refer to dates are not correct. How can
I fix it? I am pulling the dates from a list on the same sheet. Thanks again.

Here is the final working formula:
=IF((O12=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13)))),F12)

"JE McGimpsey" wrote:

> Unless O12 = 0.0001930657227898, the comparison will always be false.
>
> 12 divided by 31 divided by 2005 = 0.000193...
>
> You could force XL to parse as a date by enclosing "12/31/2005" in
> quotes, or you could use the DATE function:
>
> IF(O12=DATE(2005,12,31),....
>
>
> In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
> Bill R <BillR@discussions.microsoft.com> wrote:
>
> > =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?
>

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" <BillR@discussions.microsoft.com> wrote in message
news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> =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?
>

Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)))),F12)

"RFJ" wrote:

> You're trying to compare a cell which is formatted as a date with a multiple
> division (12 divided by 31 divided by 2005) so it will never work
>
> A quick workaround is to put your date in another cell, say z99 and then
> change your formula to
>
> If((O12=Z99,true,false)
>
>
> "Bill R" <BillR@discussions.microsoft.com> wrote in message
> news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> > =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?
> >
>
>
>

Unless O12 = 0.0001930657227898, the comparison will always be false.

12 divided by 31 divided by 2005 = 0.000193...

You could force XL to parse as a date by enclosing "12/31/2005" in
quotes, or you could use the DATE function:

IF(O12=DATE(2005,12,31),....


In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
Bill R <BillR@discussions.microsoft.com> wrote:

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

Works great! Thanks! One more question,please. When I copy the formula to
other cells the cell references that refer to dates are not correct. How can
I fix it? I am pulling the dates from a list on the same sheet. Thanks again.

Here is the final working formula:
=IF((O12=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13)))),F12)

"JE McGimpsey" wrote:

> Unless O12 = 0.0001930657227898, the comparison will always be false.
>
> 12 divided by 31 divided by 2005 = 0.000193...
>
> You could force XL to parse as a date by enclosing "12/31/2005" in
> quotes, or you could use the DATE function:
>
> IF(O12=DATE(2005,12,31),....
>
>
> In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
> Bill R <BillR@discussions.microsoft.com> wrote:
>
> > =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?
>

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" <BillR@discussions.microsoft.com> wrote in message
news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> =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?
>

Unless O12 = 0.0001930657227898, the comparison will always be false.

12 divided by 31 divided by 2005 = 0.000193...

You could force XL to parse as a date by enclosing "12/31/2005" in
quotes, or you could use the DATE function:

IF(O12=DATE(2005,12,31),....


In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
Bill R <BillR@discussions.microsoft.com> wrote:

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

Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)))),F12)

"RFJ" wrote:

> You're trying to compare a cell which is formatted as a date with a multiple
> division (12 divided by 31 divided by 2005) so it will never work
>
> A quick workaround is to put your date in another cell, say z99 and then
> change your formula to
>
> If((O12=Z99,true,false)
>
>
> "Bill R" <BillR@discussions.microsoft.com> wrote in message
> news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> > =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?
> >
>
>
>

Works great! Thanks! One more question,please. When I copy the formula to
other cells the cell references that refer to dates are not correct. How can
I fix it? I am pulling the dates from a list on the same sheet. Thanks again.

Here is the final working formula:
=IF((O12=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13)))),F12)

"JE McGimpsey" wrote:

> Unless O12 = 0.0001930657227898, the comparison will always be false.
>
> 12 divided by 31 divided by 2005 = 0.000193...
>
> You could force XL to parse as a date by enclosing "12/31/2005" in
> quotes, or you could use the DATE function:
>
> IF(O12=DATE(2005,12,31),....
>
>
> In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
> Bill R <BillR@discussions.microsoft.com> wrote:
>
> > =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?
>

Unless O12 = 0.0001930657227898, the comparison will always be false.

12 divided by 31 divided by 2005 = 0.000193...

You could force XL to parse as a date by enclosing "12/31/2005" in
quotes, or you could use the DATE function:

IF(O12=DATE(2005,12,31),....


In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
Bill R <BillR@discussions.microsoft.com> wrote:

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

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" <BillR@discussions.microsoft.com> wrote in message
news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> =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?
>

Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)))),F12)

"RFJ" wrote:

> You're trying to compare a cell which is formatted as a date with a multiple
> division (12 divided by 31 divided by 2005) so it will never work
>
> A quick workaround is to put your date in another cell, say z99 and then
> change your formula to
>
> If((O12=Z99,true,false)
>
>
> "Bill R" <BillR@discussions.microsoft.com> wrote in message
> news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> > =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?
> >
>
>
>

Thanks, but my formula does work now. I am just trying to find an eaisier way
to copy it now.
Here is what I have done to try to help it copy better:

=IF((Fin3_enddate=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(Fin3_startdate,$X1,FALSE)))*(365))*(F13)))),F12)

"RFJ" wrote:

> You're trying to compare a cell which is formatted as a date with a multiple
> division (12 divided by 31 divided by 2005) so it will never work
>
> A quick workaround is to put your date in another cell, say z99 and then
> change your formula to
>
> If((O12=Z99,true,false)
>
>
> "Bill R" <BillR@discussions.microsoft.com> wrote in message
> news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> > =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?
> >
>
>
>

You're trying to compare a cell which is formatted as a date with a multiple
division (12 divided by 31 divided by 2005) so it will never work

A quick workaround is to put your date in another cell, say z99 and then
change your formula to

If((O12=Z99,true,false)


"Bill R" <BillR@discussions.microsoft.com> wrote in message
news:7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com...
> =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?
>

Works great! Thanks! One more question,please. When I copy the formula to
other cells the cell references that refer to dates are not correct. How can
I fix it? I am pulling the dates from a list on the same sheet. Thanks again.

Here is the final working formula:
=IF((O12=DATE(2005,12,31)),(IF(ISERROR(SUM((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13),"",(SUM(((F32)/(DAYS360(N12,$X1,FALSE)))*(365))*(F13)))),F12)

"JE McGimpsey" wrote:

> Unless O12 = 0.0001930657227898, the comparison will always be false.
>
> 12 divided by 31 divided by 2005 = 0.000193...
>
> You could force XL to parse as a date by enclosing "12/31/2005" in
> quotes, or you could use the DATE function:
>
> IF(O12=DATE(2005,12,31),....
>
>
> In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
> Bill R <BillR@discussions.microsoft.com> wrote:
>
> > =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?
>

Unless O12 = 0.0001930657227898, the comparison will always be false.

12 divided by 31 divided by 2005 = 0.000193...

You could force XL to parse as a date by enclosing "12/31/2005" in
quotes, or you could use the DATE function:

IF(O12=DATE(2005,12,31),....


In article <7885A0AF-0FAB-46E9-B182-047D6F5ECF5C@microsoft.com>,
Bill R <BillR@discussions.microsoft.com> wrote:

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

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