ExcelBanter - More IF help

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

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

- - More IF help (https://www.excelbanter.com/excel-worksheet-functions/7732-more-if-help.html)

chris w

More IF help

This I know is simple, but I am more simple. :^ )

I have a cell that I want to equal another cell on the sheet, but if that
cell is empty then I want it to read an alternate cell.

JE McGimpsey

One way:

=IF(ISBLANK(A1),B1,A1)

In article ,
"chris w" wrote:

This I know is simple, but I am more simple. :^ )

I have a cell that I want to equal another cell on the sheet, but if that
cell is empty then I want it to read an alternate cell.

K.S.Warrier

Hi,
I presume you want like this.
If you have datas in columns A&B then
C1=if(A1="","",B1) "" means blank
Thank you,
k.s.Warrier

"chris w" wrote:

This I know is simple, but I am more simple. :^ )

I have a cell that I want to equal another cell on the sheet, but if that
cell is empty then I want it to read an alternate cell.

All times are GMT +1. The time now is 05:57 AM.