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
Sort By: 

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.