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

[heathercor]

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

 

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

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

 

[Ardus Petus]

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

HTH

 

[Guest]

How about

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

 

[heathercor]

Thanks Franz the formula worked perfectly!!!