jeudi 21 janvier 2016

Google Sheets - use mulitple IF statements in one cell

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