Help with a formula

Copper Contributor

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.