A rarely used portion of Google Sheets is its extensive list of functions that help us assort ... value_if_true – This is the value that comes out if the logical_expression is true value_if ...

Inserting a chart in Google Sheets. (Click image to enlarge it.) To insert a formula, click the Functions button at ... same formula cell-by-cell down a column, yet changing the formula to ...