samedi 10 octobre 2020

IF Statement Returns FALSE Instead of the Specified Value

IF statement returns FALSE instead of the specified value

Below is the formula

=IF(CJ6="Yes";IF(AND(CL6-CC6<=0);"0";IF(AND(CL6-CC6<=364;CL6-CC6>=0);(CL6-CC6);IF(CL6-CC6>364;"365";"0"))))

May you advise on where the error is sitting in, I can't get to crack it.

Regards, Morgs

Aucun commentaire:

Enregistrer un commentaire