IF Formula Question

[Cyberseeker]

Some help needed please. I have a cell that is usually left empty, and as such a different cell returns the result (lets say) "default wording" However, on occasions I type something different in the first cell, (lets say) "anything". In that case I want I want the second cell to produce the same word as typed in the first cell.

Here is my code in the second cell. Unfortunately it doesnt work. Can you tell me how to improve it?

=IF(cellwhatever="",default wording,IF(cellwhatever="anything",anything,))

[xor]

You are almost there

=IF(A1="","default wording",IF(A1="anything","anything",""))

[Cyberseeker]

I should have mentioned that the 2 cells in question are on different sheets. Can you suggest the formula in that case?

[xor]

If you have Sheet1 and Sheet2 insert this formula somewhere in Sheet2

=IF(Sheet1!A1="","default wording",IF(Sheet1!A1="anything","anything",""))

[Cyberseeker]

Thanks xor. However, I dont want the literal word, "anything". Im actually working with addresses, and the default wording is "New Zealand". However, in some cases I want to send to a country overseas. So, I may type the word, "Australia" or "United Kingdom" or "Germany". In those cases I want the cell in sheet2 to return the same word that I typed in sheet1.

Sorry that my O.P. wasnt clearer. Can you suggest again?

[xor]

What about

=Sheet1!A1