Try this:

=IF(ISNUMBER(A1),A1,A2)

Hope this helps.

Pete

On Sep 16, 9:54*am, Stefan wrote:
Hi,

I looking for an easy formula that will do the following procedu

In cell A3

If cell A1 contains a value (0 - infinity) show value of A1, if not show
value in cell A2

Regards Stefan