"IF" statement, 2 in 1 cell or combined

[MBigD011]

I have the following statement in cell E8:

=IF(A1=1,"ON","") So if A1 has 1 in it then E8 displays ON otherwise nothing

I would Also like to add the following to E8:

=IF(A1=0,"","OFF") So if A1 has 0 in it then E8 displays OFF otherwise nothing

How do u add two "IF" statements to one cell? Or is it possible to combine the above two. 1=ON, 0=OFF, Empyty = Empty

Thanks

[sweep]

=if(a1=1,"on",if(a1=0,"off",""))

ie make the second if the negative outcome of the first

[MBigD011]

=if(a1=1,"on",if(a1=0,"off",""))

ie make the second if the negative outcome of the first

I tried that its works for 1 and 0 but if A1 is empty still displays "off" and i need the target cell to display empty if a1 is empty also I tried:

=IF(A1=1,"on",IF(A1=0,"off", IF(A1<>"","")))

but same prob as above.

[sweep]

A third if then!!!

=IF(A1<>"",IF(A1=1,"on",IF(A1=0,"off","")),"")

[MBigD011]

A third if then!!!

=IF(A1<>"",IF(A1=1,"on",IF(A1=0,"off","")),"")

woot that works thank you, I started messing with a nested OR statement but couldnt figure that out.

[Rohit47]

Hi,

want ot combine two if condition how do i do?

if value is less than one then +1 or if value is greater than or equal to 1 then value remain same. Conditions are =IF(A27<1,A27+1),IF(A27>=1,A27)