Share via

Advanced excel formula

Anonymous
2022-10-12T02:45:26+00:00

Hi All,

I am trying to figure out how to populate the following excel formula with the following conditions:

If this column is Apple, show apple

If this column is Orange show orange

if this column is Apple+Orange show appleorange

Otherwise show apple

Can anyone help?

Thanks,

Best Regards,
Zoey

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-10-12T05:59:48+00:00

    BTW

    To be more specific

    =IF(A1="Orange","orange",IF(A1="Apple+Orange","appleorange","apple"))

    I hope this helps you too.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-10-12T05:53:27+00:00

    Hi there

    Please, refer to the formula and picture below for the answer to your question.

    =IF(OR(A1="Orange",A1="Apple+Orange"),A1,"Apple")

    Image

    Do let me know if you need more help

    Regards

    Jeovany

    Was this answer helpful?

    0 comments