Hi,

try this in a3

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

Mike

"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