时间戳

首页 > 解决方案 > How to change cell based on another cell value on Google Sheets

arrays - How to change cell based on another cell value on Google Sheets

问题描述

I have a Google sheet got more than 10,000 rows, so I want to change cell value based on another cell, e.g column B has 200 rows out of this 200 rows there are 74 rows have value 910, I want to change column C based on column B so if column B has 910 value change column C value to "Hail" on the same row that has 910 on B column.

标签： arraysif-statementgoogle-sheetsgoogle-sheets-formulaarray-formulas

解决方案

paste this into C1 cell:

=ARRAYFORMULA(IF(B1:B=910; "Hail"; ))

推荐阅读