ExcelBanter - Contents of cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Contents of cell (https://www.excelbanter.com/excel-worksheet-functions/45042-contents-cell.html)

Jordan

Contents of cell

Cell a1 is a formula that looks at another cell and returns a date or ""
(nothing)
Cell a2 is a formula that looks at another cell and returns a number or ""
(nothing)

Now I need a formula that looks at a1 and if the result equals "" then
return a2 otherwise return a1.

Any help will be appreciated.

Richard Buttrey

On Mon, 12 Sep 2005 15:35:01 -0700, Jordan
wrote:

Cell a1 is a formula that looks at another cell and returns a date or ""
(nothing)
Cell a2 is a formula that looks at another cell and returns a number or ""
(nothing)

Now I need a formula that looks at a1 and if the result equals "" then
return a2 otherwise return a1.

Any help will be appreciated

=if(a1="",a2,a1)

Rgds.

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

All times are GMT +1. The time now is 07:18 PM.