i'm trying to summerize three if statements in one cell but only getting a "formula parse error"
here are my statements:
IF(E_CONTRACT = "SENT"; TODAY()+7; "")
IF(E_CONTRACT = "SIGNED"; "Reminder disabled"; "")
IF(E_CONTRACT = "NOT SENT"; "-"; "")
I tried
=IF(E_CONTRACT = "SENT"; TODAY()+7; ""), IF(E_CONTRACT = "SIGNED"; "Reminder disabled"; ""), IF(E_CONTRACT = "NOT SENT"; "-"; "")
Aucun commentaire:
Enregistrer un commentaire