Hello!
In cell C1 I hace A1-B1 and in cell DI want to display the status of the cell C1 like this :
=IF(C1<>0 ; "NOT OK" ; "OK")
This means that when the value of the cell C1 is different then 0 cell D1 will display "NOT OK" and if the value of cell c1 is 0 then D1 will display "OK".
The PROBLEM:
Because the cell C1 contains a formula (A1-B1) the D1 cell will display "NOT OK" even if the cell C1 doesn't show any number.
In cell C1 I hace A1-B1 and in cell DI want to display the status of the cell C1 like this :
=IF(C1<>0 ; "NOT OK" ; "OK")
This means that when the value of the cell C1 is different then 0 cell D1 will display "NOT OK" and if the value of cell c1 is 0 then D1 will display "OK".
The PROBLEM:
Because the cell C1 contains a formula (A1-B1) the D1 cell will display "NOT OK" even if the cell C1 doesn't show any number.