Solved Excel Formula copy of cell

August 30, 2015 at 23:25:56
Specs: Windows 7
Excel had generally three sheet.
I like formula like copy to sheet1! to sheet 3
but if sheet1! any cell empty then take value from sheet2!
is this possible?

See More: Excel Formula copy of cell

Report •


#1
August 31, 2015 at 04:05:08
✔ Best Answer
Try this...

=IF(Sheet1!A1="", Sheet2!A1, Sheet1!A1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
August 31, 2015 at 08:04:34
SOLVED

THANK YOU VERY MUCH

I WILL TRY domo


Report •

Related Solutions


Ask Question