Use conditions in calculated column in sharepoint 2013

Question

I want to make a formula in my calculated column in this meaning please:

if (Column1 !=null && Column2 !=null && Column3 !=null)

Display Approved else let it empty

Answer 1

The following should work:

=IF(LEN(Column1)>0,IF(LEN(Column2)>0,IF(LEN(Column3)>0,"Approved",""),""),"")