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