WA76168 Q example

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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