Forum Discussion

Jojane's avatar
Jojane
Copper Contributor
Mar 12, 2023

Help with a formula

Was wondering if anyone could help me with this. 

I want cell B to display a value based on the below criteria. 

if cell A contains the word veggie then I want Formula A to be performed. If cell A doesn’t contain the word veggie then I want Formula B to be performed. 

1 Reply

  • Jojane 

    =IF(cellA="veggie", expression_A, expression_B)

     

    expression_A and expression_B are formulas without the = at the beginning.

Resources