IF Statement

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have three worksheets within one spreadsheet. I am
trying to create a formula that if cell 1, in worksheet 1
has something in it, the you put that in Cell 1 in
worksheet 3, however if you have nothing in that cell, but
have something in cell 1, in worksheet 2, then you put
that in cell 1 of worksheet 3?

I really hope this makes sense?
 
Hi John,

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

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
John

=IF(Sheet1!A1<>0,Sheet1!A1,Sheet2!A1)

Note: If there is something in both sheets Sheet 1 value
is returned.

Regards
Peter
 
Back
Top