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