IF =IF(logical_test, [value_if_true], [value_if_false]) Checks whether a condition is met, and returns one value if TRUE and another value if FALSE AND =AND(logical1, [logical2], …) Checks whether all arguments are …
TRIM =TRIM(text) Removes all space from a text string except for single spaces between words CONCATENATE =CONCATENATE(text1, [text2], …) Joins several text strings into one text string LEN =LEN(text) Returns …
SUBTOTAL =SUBTOTAL(function_num, ref1, [ref2], …) Returns a subtotal in a list or database SUBTOTAL
ROUND =ROUND(number, num_digits) Rounds the number to a specified number of digits ROUNDUP =ROUNDUP(number, num_digits) Rounds a number up, away from zero ROUNDDOWN =ROUNDDOWN(number, num_digits) Rounds a number down, toward …
EOMONTH =EOMONTH(start_date, months) Returns the serial number of the last day of the month before or after a specified number of months and start of month DAY =DAY(serial_number) Returns the …
DAYS =DAYS(end_date, start_date) Returns the number of days between two dates NETWORKDAYS =NETWORKDAYS(start_date, end_date, [holidays]) Returns the number of whole workdays between two dates NOW =NOW() Returns the current date …
COUNT =COUNT(value1, [value2], …) Counts the number of cells in a range that contains numbers COUNTIF =COUNTIF(range, criteria) Counts the number of cells within a range that meet the given …
SUM =SUM(number1, [number2], …) Adds all the numbers in a range of cells SUMIF =SUMIF(range, criteria, [sum_range]) Adds the cells specified by a given condition or criteria SUMIFS =SUMIFS(sum_range, criteria_range1, …
This post is to take you through how to integrate your Google Home with your Home Assistant/Hassio. The Home Assistant website has a detailed guide including links at the following …
In order to access your Hass.io instance from outside of your network, you will need to enable remote access. This is also a prerequisite for enabling the Google Home integration. …
