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

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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.