ExcelBanter - Return a value to a cell that is blank

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Return a value to a cell that is blank (https://www.excelbanter.com/excel-discussion-misc-queries/128824-return-value-cell-blank.html)

hilltop55

Return a value to a cell that is blank

Cell A2 is blank, I want a formula to look at A2 if it is blank I want to
return the value from A3; if cell A2 is not blank do nothing.
--
Thanks for your help.

Elkar

Return a value to a cell that is blank

Try this:

=IF(A2="",A3,"")

HTH,
Elkar

"hilltop55" wrote:

Cell A2 is blank, I want a formula to look at A2 if it is blank I want to
return the value from A3; if cell A2 is not blank do nothing.
--
Thanks for your help.

T. Valko

Return a value to a cell that is blank

Try this:

=IF(A2="",A3,"")

Biff

"hilltop55" wrote in message
...
Cell A2 is blank, I want a formula to look at A2 if it is blank I want to
return the value from A3; if cell A2 is not blank do nothing.
--
Thanks for your help.

All times are GMT +1. The time now is 09:59 AM.