want a "," in the output of a formula, what am i missing?

[James C]

I have a formula: =IF(A1<=0,A2,"")
and it works fine.

But what I really want is:
=IF(A1<=0,A2",","")
note the comma after the A2; excel rejects this

;help?

thanx!

[johan_vrolijk]

Hi there,

The way I understand your problem:

You have:

A1 = -10
A2 = 5

And you want:

A3 = 5,

Put this formula in A3: =IF(A1<=0,A2&",","")

Regards
Johan