Google-sheets – The cell is filled with $0,00 but IF(Cell >0;True;False) return True

formulasgoogle sheets

In Google Sheets, when I compare a Cell filled with $0,00 using:

CELL [$0,00]

IF(Cell > 0; true; false).

It returns true, but Cell is = 0. It should return false.

It seems to be related to floating point. What can I do to IF consider $0,00 equal to 0?

P.S. I did the same formula in another Google sheet but there the sheet consider $0,00 equal to 0 and return false.

Best Answer

in terms of currency it's safe to introduce a small fix with ROUNDDOWN formula to ensure that $0.001 of the cent is considered as $0.00

Related Solutions

Google Sheets Formulas – Using the ISBLANK() Function

You can check whether a cell is empty or not by using the following formula:

=if(C2="";"The cell is empty";"The cell is not empty")

Google-sheets – Return a blank when cell reference is blank

Google Sheets as well as other spreadsheet application handles dates as serialized number. The large number that you refer that is displayed when a cell on AL column is blank is very likely that it is the number that represents the date on the corresponding cell on column G.

Regarding returning a blank, try something like this:

=ArrayFormula(IF(ISBLANK(A:A),,"Non blank"))

Please note that the second argument of the IF() function is left empty (,,): IFS(), IF() and other similar functions return blank when the corresponding argument is empty.

Best Answer

Related Solutions

Google Sheets Formulas – Using the ISBLANK() Function

Google-sheets – Return a blank when cell reference is blank

Related Topic