Stack Exchange network consists of 178 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I need help with the question in the picture.
Can anyone make a formula for me?
You're looking for the IF command, combined with NE (not equal):
IF(NE(RedCellReference,"No"), LeftCellReference, "")
For the cell you could also use this formula.
=IF(F2 <> "No", B2, "")
For the complete column you can use this formula.
=ARRAYFORMULA(IF(F2:F <> "No", B2:B, ""))
Assuming the relevant columns are C, D and G, slightly shorter:
but will return #VALUE! if the C column entry is Text and requires ColumnD be formatted something like:
(Blanks in G will be populated in C.)
Required, but never shown