Google Sheets – How to Check if Value is Given in Cell

google sheets

I want to check if the value is given in the cell, start time and end time.

It works fine now with the function like this:

=if(and(C9 > 0, B9 > 0),C9-B9, 0)

But instead of 0 I and to check the condition not equal FALSE.

=if(and(C9 != FALSE, B9 != FALSE),C9-B9, 0)

But the != operator is not supported in google spread sheet.
How can I check if the value is not given in the cell?

Best Answer

The "not equal" operator in Google Sheets is <>, not !=.

Alternatively, you could recast the formula as 

=if(or(C9 = FALSE, B9 = FALSE), 0, C9-B9)
Related Topic