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

H

heathercor

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

Franz Verga

Nel post *heathercor* ha scritto:
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
"-".
Click to expand...

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
 
B

Barb Reinhardt

How about

=if(or('6"PLANTS'!B23="XCANE",'6"PLANTS'!B23="XTIP"),'6"PLANTS'!B23,"-")
 
Top