# IF,or IF--so sick of IF's

1. ## IF,or IF--so sick of IF's

I want two IF's, not totally sure how to do it

=IF('6"PLANTS'!B23="XCANE", "XCANE", "-")
or
=IF('6"PLANTS'!B23="XTIP", "XTIP", "-")

So basically if '6PLANTS'!B23 says XCANE I want it to show as XCANE, if it says XTIP I want it to say XTIP; Otherwise I want it to show "-".

2. ## Re: IF,or IF--so sick of IF's

Nel post news:heathercor.29redt_1150905076.3827@excelforum-nospam.com
*heathercor* ha scritto:

> I want two IF's, not totally sure how to do it
>> confused:

> =IF('6"PLANTS'!B23="XCANE", "XCANE", "-")
> or
> =IF('6"PLANTS'!B23="XTIP", "XTIP", "-")
>
> So basically if '6PLANTS'!B23 says XCANE I want it to show as XCANE,
> if it says XTIP I want it to say XTIP; Otherwise I want it to show
> "-".

Hi Heathercor

Maybe it should be:

=IF('6"PLANTS'!B23="XCANE", "XCANE", IF('6"PLANTS'!B23="XTIP", "XTIP", "-"))

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy

3. ## Re: IF,or IF--so sick of IF's

Nel post news:heathercor.29redt_1150905076.3827@excelforum-nospam.com
*heathercor* ha scritto:

> I want two IF's, not totally sure how to do it
>> confused:

> =IF('6"PLANTS'!B23="XCANE", "XCANE", "-")
> or
> =IF('6"PLANTS'!B23="XTIP", "XTIP", "-")
>
> So basically if '6PLANTS'!B23 says XCANE I want it to show as XCANE,
> if it says XTIP I want it to say XTIP; Otherwise I want it to show
> "-".

Hi Heathercor

Maybe it should be:

=IF('6"PLANTS'!B23="XCANE", "XCANE", IF('6"PLANTS'!B23="XTIP", "XTIP", "-"))

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Ciao

Franz Verga from Italy

4. ## Re: IF,or IF--so sick of IF's

=IF(OR('6PLANTS'!B23="XCANE",'6PLANTS'!B23="XTIP"),'6PLANTS'!B23,"-")

HTH
--
AP

"heathercor" <heathercor.29redt_1150905076.3827@excelforum-nospam.com> a
écrit dans le message de news:
heathercor.29redt_1150905076.3827@excelforum-nospam.com...
>
> I want two IF's, not totally sure how to do it
>
> =IF('6"PLANTS'!B23="XCANE", "XCANE", "-")
> or
> =IF('6"PLANTS'!B23="XTIP", "XTIP", "-")
>
> So basically if '6PLANTS'!B23 says XCANE I want it to show as XCANE, if
> it says XTIP I want it to say XTIP; Otherwise I want it to show "-".
>
>
> --
> heathercor
> ------------------------------------------------------------------------
> heathercor's Profile:
> http://www.excelforum.com/member.php...o&userid=35630
>

5. ## RE: IF,or IF--so sick of IF's

=if(or('6"PLANTS'!B23="XCANE",'6"PLANTS'!B23="XTIP"),'6"PLANTS'!B23,"-")

"heathercor" wrote:

>
> I want two IF's, not totally sure how to do it
>
> =IF('6"PLANTS'!B23="XCANE", "XCANE", "-")
> or
> =IF('6"PLANTS'!B23="XTIP", "XTIP", "-")
>
> So basically if '6PLANTS'!B23 says XCANE I want it to show as XCANE, if
> it says XTIP I want it to say XTIP; Otherwise I want it to show "-".
>
>
> --
> heathercor
> ------------------------------------------------------------------------
> heathercor's Profile: http://www.excelforum.com/member.php...o&userid=35630
>
>

6. ## thanks

Thanks Franz the formula worked perfectly!!!!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1