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

Question

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

The two cells are:

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

An help on how to compare these cells?

score 2 · Accepted Answer · answered May 30 '22 at 19:15

2

use just one = sign:

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

answered May 30 '22 at 19:15

player0

score 1 · Answer 2 · answered May 30 '22 at 17:44

Tested your scenario and found out that if you have values on E5 and H5, then it works as long as it is numeric. Do something like

=IF(AND(ISNUMBER(E5), ISNUMBER(J5)), E5-J5, "")

So, if both cells are numbers, we subtract them, otherwise we have an empty value.

2 Answers2