good day to all!
hope doing good!
i would like to ask a help with my formula.
if i have a (random text in the column) i want to return (the word "check" in the other column) and if the column is blank to return a blank.
kindly refer to the following example
hope doing good!
i would like to ask a help with my formula.
if i have a (random text in the column) i want to return (the word "check" in the other column) and if the column is blank to return a blank.
kindly refer to the following example
Book1 | |||||||
---|---|---|---|---|---|---|---|
F | G | H | I | J | |||
1 | |||||||
2 | |||||||
3 | ANTI-B | CHECK | should return check | ||||
4 | ANTI-A | CHECK | |||||
5 | CHECK | should return blank | |||||
6 | HI | CHECK | |||||
7 | BYE | CHECK | |||||
8 | DONE | CHECK | |||||
9 | CHECK | ||||||
10 | CHECK | ||||||
11 | CHECK | ||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
G3:G11 | G3 | =IF($F$3:$F$30=$F3,"CHECK","") |