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 "-".
Bookmarks