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