Value versus ""

[Pericic]

Simple question guys, but I can't figure it out....

In Cell A1 I enter the value 0 (or any other value)

In another cell I enter the formula: =If(A1>"",A1,"")

Why is If(A1>"") FALSE ??? Isn't 0>""?????

Thanks in advance
Romeo

 

[Joe4]

No. O denotes a numeric entry, "" denotes a Text entry.

If you are checking for the existence of a value, try:
=If(LEN(A1)>0,A1,"")

 

[Pericic]

Thanks jm14...
I''m not checking for existence of value.....
I make entries in cells and if it is anything but an empty cell (which is by default 0) I use it elsewhere....

My problem arises when my entered value happens to be 0....cannot differentiate it from cells where I didn't enter anything (default is also 0)

Your time is much appreciated..

 

[Scott Huish]

I''m not checking for existence of value.....

Not sure what you mean by that, because if there is a value you use it, otherwise not. Is this not checking for a value?


How about:

=IF(ISNUMBER(A1),A1,"")

 

[richarddec]

How about this:

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

This will display whatever is in cell A1 if that cell is not empty. Not sure what exactly your using it for, and am unsure if I even understood what you wanted. Hope this helped. I have alot of payback to do for the help I have gotten on here.

 

[Pericic]

Thanks to all...

I guess isnumber is the way to go....

 

[Joe4]

Thanks jm14...
I''m not checking for existence of value.....
I make entries in cells and if it is anything but an empty cell (which is by default 0) I use it elsewhere....

My problem arises when my entered value happens to be 0....cannot differentiate it from cells where I didn't enter anything (default is also 0)

My response does that. It uses the Length function. An entry of zero has a length of 1, where no entry has a length of 0. So it differentiates entries of zero from no entry.

 

[Peter_SSs]

What about the even simpler (slightly) version of richarddec's suggestion?
=IF(A1="","",A1)