+ Reply to Thread
Results 1 to 6 of 6

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

  1. #1
    Registered User
    Join Date
    06-21-2006
    Location
    UTAH
    Posts
    2

    Question 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. #2
    Franz Verga
    Guest

    Re: IF,or IF--so sick of IF's

    Nel post news:[email protected]
    *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. #3
    Franz Verga
    Guest

    Re: IF,or IF--so sick of IF's

    Nel post news:[email protected]
    *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. #4
    Ardus Petus
    Guest

    Re: IF,or IF--so sick of IF's

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

    HTH
    --
    AP

    "heathercor" <[email protected]> a
    écrit dans le message de news:
    [email protected]...
    >
    > 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
    > View this thread: http://www.excelforum.com/showthread...hreadid=554117
    >




  5. #5
    Barb Reinhardt
    Guest

    RE: IF,or IF--so sick of IF's

    How about

    =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
    > View this thread: http://www.excelforum.com/showthread...hreadid=554117
    >
    >


  6. #6
    Registered User
    Join Date
    06-21-2006
    Location
    UTAH
    Posts
    2

    thanks

    Thanks Franz the formula worked perfectly!!!!
    "You can shoot for the stars and miss by a mile or shoot for a manure pile and hit it dead on!"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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