WA76168 Q example

I need help with the question in the picture.

Can anyone make a formula for me?


3 Answers 3


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.)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.