mercredi 5 février 2020

Excel conditional IF value greater than zero only reporting TRUE

I have a spreadsheet with a column containing values such as: -10, 0, 32, 70, -23

I want to create a column based off the first column, and this column should display either TRUE or FALSE values. It should display TRUE if the value of the first column is greater than 0, and FALSE if the value is equal 0 or less than 0 (so those minus values).

I used the simple formula:

=IF(O9 > 0,"TRUE","FALSE")

But the output of the column is TRUE for everything, even for instances where the value was 0 or less than zero. I even tried > 1 but it's the same. I don't understand what I am doing wrong!

Thank you!

Aucun commentaire:

Enregistrer un commentaire