Search code examples
if-statementgoogle-sheetsbooleanboolean-logicnested-if

How to compare two formula (calculated) cells in Google Sheets


I am trying to compare two formula (calculated) cells in Google Sheets but I am getting: Error - Formula parse error.

The two cells are:

  • =IF(OR(ISBLANK(E5), ISBLANK(H5)),"", E5-H5)
  • =IF(OR(ISBLANK(E5), ISBLANK(J5)),"", E5-J5)

And the cell I am trying to compare them in is:

  • =IF(K5==K4, "yes", "no")

An help on how to compare these cells?


Solution

  • use just one = sign:

    =IF(K5=K4, "yes", "no")