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
route217Asked:
Who is Participating?
 
NBVCCommented:
=IF(A1="","out",IF(A1>0,"in",""))

if not working try:

=IF(ISBLANK(A1),"out",IF(A1>0,"in",""))
0
 
NBVCCommented:
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
 
Rgonzo1971Commented:
HI,

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

Open in new window

Regards
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
andrew_manCommented:
=if(A1="",if(A1>0,"x",""),"")
0
 
NBVCCommented:
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
 
Mohit VijayCommented:
=IF(A1="","",IF(A1>0,"x",""))
0
 
andrew_manCommented:
Yes, agreed!
0
 
route217Author 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
 
andrew_manCommented:
Can explain more clear what is "then in" and "then out"?
0
 
route217Author Commented:
I.e....the person is in work
0
 
NBVCCommented:
or

=IF(A1<>"","in","out")
0
 
andrew_manCommented:
=if((A1=1)+(A1=2)+(A1=3),"In",if(A1="","out",""))
0
 
route217Author Commented:
Nb vc....The formula works but I do not get out if blank
0
 
NBVCCommented:
Then is it blank or is there a space?

Is this working?

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

or:

=IF(TRIM(A1)<>"","in","out")
0
 
andrew_manCommented:
=IF((A1=1)+(A1=2)+(A1=3),"In",IF(TRIM(A1)="","out",""))
0
 
andrew_manCommented:
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.

All Courses

From novice to tech pro — start learning today.