Formula

E

Eán

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
 
A

Alan McQuaid via OfficeKB.com

Hi,

You could use the formula:

=IF(B1<>0,B1,A1)

Then copy the formula down Column C as required.

Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
countifs Function not giving desired result with date criteria 2
Cobditional Formatting Rows based on dates in action plan. 0
Returning a Date with Multiple Criteria Lookup Values 0
Use TODAY() function as the criteria in a SUMIF formula 1
Horizontal and Vertical lookup 2
Need formulas for searching for a value in a table and returning row/column name 7

Top