How to make a formula in Google spreadsheets, insert the text “required resource” if the adjacent cell contains text, and if the adjacent cell is empty, then it is also empty?

S

Stewie882018-06-02 20:05:50

Google Sheets

Stewie88, 2018-06-02 20:05:50

When working in a Google spreadsheet, help me create a formula so that the phrase "Required resource" appears in the cell of column C if there is any text in the cell of column D. If cell D is empty, then C must also be empty.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Kiselyov, 2018-06-06
@zamboga

=IF(ISBLANK(D1),"";"Required resource.")
And drag the formula down.