route217
asked on
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
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
HI,
=IF(A1="", "in", IF(A1>0,"x"))
Regards
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
probably Rgonzo interpreted it most correctly. I didn't catch the OP might want the word "in" if A1 was blank.
=IF(A1="","",IF(A1>0,"x"," "))
Yes, agreed!
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Can explain more clear what is "then in" and "then out"?
ASKER
I.e....the person is in work
or
=IF(A1<>"","in","out")
=IF(A1<>"","in","out")
=if((A1=1)+(A1=2)+(A1=3)," In",if(A1= "","out"," "))
ASKER
Nb vc....The formula works but I do not get out if blank
Then is it blank or is there a space?
Is this working?
=IF(A1<>" ","in","out")
or:
=IF(TRIM(A1)<>"","in","out ")
Is this working?
=IF(A1<>" ","in","out")
or:
=IF(TRIM(A1)<>"","in","out
=IF((A1=1)+(A1=2)+(A1=3)," In",IF(TRI M(A1)=""," out",""))
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
Andrew Man from Hong Kong
=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.