lundi 4 mars 2019

Excel doesn't accept any IF statment

I tried to use this statment

=IF(C15-E14<=0 ,"", C15-E14)

All i wanted was if the subtraction value is zero or negative then show blank, else show the subtraction result.

The excel always highlights the middle part ,"", without giving instructions to fix the error

i formatted the cell to general but it didn't work

Thanks in advance.

Aucun commentaire:

Enregistrer un commentaire