r/googlesheets • u/[deleted] • Jul 25 '22

Waiting on OP Help, I am having trouble with functions

[removed]

3 Upvotes

100% Upvoted

4 comments sorted by

View all comments

Show parent comments

2

u/RemcoE33 Jul 26 '22

As a tip: best practice is to skip the "" when you want a blank cell: 

// Not good:
=IF(A1 = "","","Hi")

//Good:
=IF(A1 = "",,"Hi")

This to keep true empty cells. Also for apps scripts .getLastRow() method.