honestly I don't know what the problem is but perhaps you might help me finding out. I have a column A with percentages (positive and negative ones). In Column B, I would like to get the value "TRUE" if the respective cell in column A is positive and "False" if it is negative).
My formula in Column B for example for cell 2 is =IF(A2>0,"TRUE","FALSE").
Instead of giving me the correct value, I end up getting only TRUEs... I also tried to use SIGN but it didn't work either.
Aucun commentaire:
Enregistrer un commentaire