Apple launches Apple Store app in India
The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >
The Apple Store app provides customers with the most personalized way to shop for Apple’s innovative lineup of products and services. Learn more >
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
Hi hayley,
Nested IF formulas are often difficult to create and debug.
A lookup function may do the trick.
XLOOKUP is your friend.
Formula in Table 1 C2 is XLOOKUP(A2,Lookup::A,Lookup::B,"Not Found",0)
Fill down.
More information here:
Regards,
Ian.
How do I apply multiple formulas to one column?
