sum if
 

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

sum if
 

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

sum if
 

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

sum if
 

"Stefan" wrote:
I looking for an easy formula that will do the following procedu
[....]
If cell A1 contains a value (0 - infinity) show value of A1,
if not show value in cell A2

Often, the following is sufficient:

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

But if A1 might contain other text and you want A2 in that case, then you
need:

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

I also note that you say "0 to infinity". If A1 might contain a negative
number and you want A2 in that case as well, then you need one of the
following:

=IF(AND(A1<"",A1=0),A1,A2)

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

Finally, if A1 might contain an Excel error (e.g. #NUM, #DIV/0 or #NA) and
you want A2 in that case as well, then you need one of the following:

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

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

But generally, is preferrable to avoid Excel errors in a cell.


----- original message -----

"Stefan" wrote in message
...
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