CODEWITHSUNDEEP
google-sheetsspreadsheet
Ellone
Ellone

Reputation: 3898

Using IF in google spreadsheet cell returns #ERROR

I am starting to use google spreadsheet to manage some dates for personal convenience and this formula for a cell returns me #ERRROR!

=IF(ISBLANK(C1), "Unknown datetime", C1 + 3/24)

Any idea what's wrong ?

I'm probably not setting things at the right place, here is a basic sample : Screenshot

Upvotes: 0

Views: 85

Answers (2)

Chris
Chris

Reputation: 868

  1. Make sure A1 is formatted to time - Format > Number > Time.
  2. If you change the date to 03/03/2016 11:54:15, does it work? If yes, the expected date format is date/month/year while you have month/date/year in the cell.

Upvotes: 0

user4039065
user4039065

Reputation:

If you want to add 8 hours to A1, then add it as Time.

=IF(ISBLANK(A1), "Unknown datetime", A1 +time(8, 0, 0))

    googlesheets_add_time

Upvotes: 2

Related Questions