# if formula

Hi Expert's

need an if formula to do the following. ..

if cell a1 is blank then in if a1 has a value greater then 0 then x
###### Who is Participating?

Commented:
=IF(A1="","out",IF(A1>0,"in",""))

if not working try:

=IF(ISBLANK(A1),"out",IF(A1>0,"in",""))
0

Commented:
Do you mean?

=IF(A1>0,"x","")

this will return an x if A1 has a value greater than 0, else it will return a blank, including when A1 is blank.
0

Commented:
HI,

``````=IF(A1="", "in", IF(A1>0,"x"))
``````
Regards
0

Commented:
=if(A1="",if(A1>0,"x",""),"")
0

Commented:
andrew_man, if A1 is blank, then how can A1 be greater than 0?

probably Rgonzo interpreted it most correctly.  I didn't catch the OP might want the word "in" if A1 was blank.
0

Commented:
=IF(A1="","",IF(A1>0,"x",""))
0

Commented:
Yes, agreed!
0

Author Commented:
Sorry experts

Not Woking. ....what I am trying to do is if cell a1 us blank then out...if cell a1 has number 1 or 2 or 3 then in
0

Commented:
Can explain more clear what is "then in" and "then out"?
0

Author Commented:
I.e....the person is in work
0

Commented:
or

=IF(A1<>"","in","out")
0

Commented:
=if((A1=1)+(A1=2)+(A1=3),"In",if(A1="","out",""))
0

Author Commented:
Nb vc....The formula works but I do not get out if blank
0

Commented:
Then is it blank or is there a space?

Is this working?

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

or:

=IF(TRIM(A1)<>"","in","out")
0

Commented:
=IF((A1=1)+(A1=2)+(A1=3),"In",IF(TRIM(A1)="","out",""))
0

Commented:
Why give me the point? I dun think I can help you.  But, I really want to tell me more actually.

Andrew Man from Hong Kong
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.