Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

How do I apply multiple formulas to one column?

Ie if C=Bananas, if true, ExB34

if C=Apples, if true, ExB35

if C=Grapes, if true, ExB36


The E column being Quantity and B column being the Current Price


I want to apply all 3 formluas to 1 column dependant on the C column answer


I have tried if C=Bananas, if true, ExB34(&)C=Apples, if true, ExB35(&)C=Grapes, if true, ExB36


but I am getting a syntax error please help :)


iPhone 15 Plus, iOS 18

Posted on Jan 18, 2025 3:55 AM

Reply
1 reply

How do I apply multiple formulas to one column?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.