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

Nel post
*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

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

HTH
--
AP

"heathercor" a
écrit dans le message de news:
...

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

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

Thanks Franz the formula worked perfectly!!!!


--
heathercor

25, Mom of 3.
------------------------------------------------------------------------
heathercor's Profile: http://www.excelforum.com/member.php...o&userid=35630
View this thread: http://www.excelforum.com/showthread...hreadid=554117