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
>
>