Excel Formule

[Roel]

Heyz,

Im not very good with formules, thats why im asking my question here.



I want a formule that says:

IF A3 is empty then put result A1 in A3, if A1 is empty, then put result A2 in A3. If both A1 + A2 is empty, then show ! in A3.

Can any1 make me a proper and working formule of this?

Thanks in advance!

[Colin Legg]

The wording here is circular:

IF A3 is empty then put result A1 in A3

However, I hope, in fact, that you want to put a formula in A3 and that formula would be this:

=IF(A1<>"",A1,IF(A2<>"",A2,"!"))