excel if statements with multiple conditions

[kelvin_9]

greeting to all
can someone point me out how can i use a if statments with 3(or more) conditions listed below?
i need a formula in cell c1 that says:

if a1=0, leave it blank, ""
if a1>0, "reutrn"
if a1<0, "pick"

thanks in advance

 

[Georgiboy]

Maybe:

=IF(A1=0,"",IF(A1>0,"return",IF(A1<0,"pick")))

 

[Georgiboy]

Or maybe even:

=IF(A1>0,"return",IF(A1<0,"pick",""))

 

[Peter_SSs]

For that particular example, no need to use IF at all

23 06 27.xlsm
	A	B
1	3	return
2	0
3	-2	pick
Sheet3

Cell Formulas
Range	Formula
B1:B3	B1	=CHOOSE(SIGN(A1)+2,"pick","","return")

 

[Kyser Ahmad]

greeting to all
can someone point me out how can i use a if statments with 3(or more) conditions listed below?
i need a formula in cell c1 that says:

if a1=0, leave it blank, ""
if a1>0, "reutrn"
if a1<0, "pick"

thanks in advance

hi sir, You can use nested if inthis case if your return query is only these three results,

formulla
if(A1=0,"",if(a1>0,"Return",if(a1<0,"Pick")))
in case if value in A1=0, c1 will be blank
and in case if value in A1>0, Value in C1 is return, and incase if A1<0 value in C1 will be pick

 

[kelvin_9]

Maybe:

=IF(A1=0,"",IF(A1>0,"return",IF(A1<0,"pick")))

this is just perfect

thank you Georgiboy

 

[kelvin_9]

For that particular example, no need to use IF at all

23 06 27.xlsm
	A	B
1	3	return
2	0
3	-2	pick
Sheet3

Cell Formulas
Range	Formula
B1:B3	B1	=CHOOSE(SIGN(A1)+2,"pick","","return")

unless i dont well understand this formula running, but this is real amazing
thank you Peter_SSs

 

[kelvin_9]

another if statmen would like to amend, if this 2 can work with a "✓" if value is below or equal to 5

=IF(SIGN(E3)=SIGN(J3),E3-J3,E3+J3)

 

[kelvin_9]

hi sir, You can use nested if inthis case if your return query is only these three results,

formulla
if(A1=0,"",if(a1>0,"Return",if(a1<0,"Pick")))
in case if value in A1=0, c1 will be blank
and in case if value in A1>0, Value in C1 is return, and incase if A1<0 value in C1 will be pick

thank you so much for your guidance

 

[Peter_SSs]

this is just perfect

thank you Georgiboy

But it does have a wasted IF function (as does post #5). Only two IF functions are needed - as shown in @Georgiboy's other suggestion in post #3.