CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
cjwrk
cjwrk

Reputation: 295

If cell is blank, show value in the another cell

I'm working on two cells, one in column P and the other in column T. (see the image below).

For the column P, I used =if(REGEXMATCH(I2,"Grade 7"),REPLACE(I2,1,9,""),"") as a formula so it means that the cell is not empty, right? So, the goal is to have cell T17 return blank when cell P17 has no value or returns as blank.

sample image

Upvotes: 2

Views: 2189

Answers (1)

cjwrk
cjwrk

Reputation: 295

I already figured it out.

The formula that I used for cell T19: =IF(P17="","","2021-2022")

Upvotes: 3

Related Questions