Help please - how do I write a formula that will return the value of one of
two columns of data, for example, column A contains dates and column B
contains some dates, I want column C to return the date in A or if there is a
date in B supercede it with that one?
So, if there is a date in B return that date in C or if B is blank return
the date in A.
Hope this makes sense?
Many thanks
Eán

=IF(ISBLANK(B2),A2,B2)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eán" wrote:

Help please - how do I write a formula that will return the value of one of
two columns of data, for example, column A contains dates and column B
contains some dates, I want column C to return the date in A or if there is a
date in B supercede it with that one?
So, if there is a date in B return that date in C or if B is blank return
the date in A.
Hope this makes sense?
Many thanks
Eán

Hi,

You could use the formula:

=IF(B1<0,B1,A1)

Then copy the formula down Column C as required.

Alan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1