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

  • 3
    Can you try this please =IF(LEN(Column1)>0,IF(LEN(Column2)>0,IF(LEN(Column3)>0,"Approved",""),""),"") Jul 26, 2018 at 9:37
  • Yes it work Arslan thnx :)
    – Jihen
    Jul 26, 2018 at 9:48
  • I've posted it as an answer :) Jul 26, 2018 at 9:49

1 Answer 1


The following should work:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.