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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
NBVCConnect With a Mentor Commented:
=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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
andrew_manConnect With a Mentor Commented:
=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
All Courses

From novice to tech pro — start learning today.