• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

multiple conditions

ahhhmed

Member
Hi all,


In A2 I have a text that I would change.

In A3 I want to have a condition that does the following:

If A2 = grapes then A3 shows fruit

If A2 = lettuce then A3 shows vegetables

If A2 = veal then A3 shows meat

If A2 = anything else A3 shows poultry

How can I write the formula?
 
Hi, ahhhmed!

In A3 type: =IF(A2="grapes","fruit",IF(A2="lettuce","vegetables",IF(A2="veal","meat","poultry")))

Regards!
 
Make particular normally the women north face sale clothes just isnt in reality a fantastic give too unattractive for the north face selling the goal whatever will get normally the garments very practically non-wearable a perform result of level of privacy consideration.cheap north face? you need to build a choice after movement image The particular North Face Top Bionic Jackets which could well be thinner but nevertheless certainly will however furnish tenderness never to mention dryness.
 
Back
Top