Help with calulating Null fields
 

Tried this formula, but it doesn't work...

=IF(B2="", [A2], [B2])

I THOUGHT the formula above basically was saying, "if B2 is null then put
the A2 data in this field".

Trying to calulate dates for tasks...
Column A has the due date
Column B has the actual completion date
Column C should have the formula
Column D should have the results of column C minus column A

The idea is to show what tasks are late. For calculation purposes though
(and ease of use for the end user) if there is no "Actual Completion Date" in
the spreadsheet - in other words, if the task is still in progress, then I
just want the number to return as zero.

Help with calulating Null fields
 

why do you have brackets?
=IF(B2="",A2,B2)
--
John C


"Roderic" wrote:

Tried this formula, but it doesn't work...

=IF(B2="", [A2], [B2])

I THOUGHT the formula above basically was saying, "if B2 is null then put
the A2 data in this field".

Trying to calulate dates for tasks...
Column A has the due date
Column B has the actual completion date
Column C should have the formula
Column D should have the results of column C minus column A

The idea is to show what tasks are late. For calculation purposes though
(and ease of use for the end user) if there is no "Actual Completion Date" in
the spreadsheet - in other words, if the task is still in progress, then I
just want the number to return as zero.

Help with calulating Null fields
 

Thanks, John! That helped! I was following the format suggested in the
pop-ups in MS Office 2007.

"John C" wrote:

why do you have brackets?
=IF(B2="",A2,B2)
--
John C


"Roderic" wrote:

Tried this formula, but it doesn't work...

=IF(B2="", [A2], [B2])

I THOUGHT the formula above basically was saying, "if B2 is null then put
the A2 data in this field".

Trying to calulate dates for tasks...
Column A has the due date
Column B has the actual completion date
Column C should have the formula
Column D should have the results of column C minus column A

The idea is to show what tasks are late. For calculation purposes though
(and ease of use for the end user) if there is no "Actual Completion Date" in
the spreadsheet - in other words, if the task is still in progress, then I
just want the number to return as zero.

Help with calulating Null fields
 

I don't have xl2007, I can only imagine that they have the brackets around
those two items to indicate what the cell display will be (i.e.: value of A2
or value of B2). Perhaps someone else with xl2007 could answer that.

Thanks for the feedback.
--
John C


"Roderic" wrote:

Thanks, John! That helped! I was following the format suggested in the
pop-ups in MS Office 2007.

"John C" wrote:

why do you have brackets?
=IF(B2="",A2,B2)
--
John C


"Roderic" wrote:

Tried this formula, but it doesn't work...

=IF(B2="", [A2], [B2])

I THOUGHT the formula above basically was saying, "if B2 is null then put
the A2 data in this field".

Trying to calulate dates for tasks...
Column A has the due date
Column B has the actual completion date
Column C should have the formula
Column D should have the results of column C minus column A

The idea is to show what tasks are late. For calculation purposes though
(and ease of use for the end user) if there is no "Actual Completion Date" in
the spreadsheet - in other words, if the task is still in progress, then I
just want the number to return as zero.