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?
use just one = sign:
=IF(K5=K4, "yes", "no")