Two formulas in one cell?

[The Stoat]

Hi all,

Is it possible to have two formulas in one cell? For example, here's what
I'm trying to do:

If cell A1 has the word HORSE in it, I want the formula in A2 to be x + z
If cell A1 has the word PIG in it, I want the formula in A2 to be x * z

Anyone know if that's possible?

Many thanks,

Matt.

 

[Peo Sjoblom]

If the lower upper case does not matter

=IF(A1="horse",x+z,IF(A1="pig",x*z,""))

if it matters

=IF(--EXACT(A1,"HORSE")=1,x+z,IF(--EXACT(A1,"PIG")=1,x*z,""))

or

=IF(ISNUMBER(FIND("HORSE",A1)),x+z,IF(ISNUMBER(FIND("HORSE",A1)),x*z,""))

 

[The Stoat]

Great, thanks - I'll give that a go!

Matt.

If the lower upper case does not matter

=IF(A1="horse",x+z,IF(A1="pig",x*z,""))

if it matters

=IF(--EXACT(A1,"HORSE")=1,x+z,IF(--EXACT(A1,"PIG")=1,x*z,""))

or

=IF(ISNUMBER(FIND("HORSE",A1)),x+z,IF(ISNUMBER(FIND("HORSE",A1)),x*z,""))

--

Regards,

Peo Sjoblom