G
Guest
how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3
if B8=Adelaide or mackay or katherine or darwin then c8 = 3
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
--
Kevin Backmann
Kevin Backmann
A
Alan
In C8
=IF(OR(B8="Adelaide",B8="mackay",B8="darwin"),3,)
Regards,
Alan.
=IF(OR(B8="Adelaide",B8="mackay",B8="darwin"),3,)
Regards,
Alan.
T
T. Valko
Enter this formula in C8:
=IF(OR(B8={"Adelaide","Mackay","Katherine","Darwin"}),3,"")
=IF(OR(B8={"Adelaide","Mackay","Katherine","Darwin"}),3,"")
G
Guest
sorry kevin i dont get your answer does -- mean or.
G
Guest
My system appears to have hiccupped while sending the reply. The function
that I suggested that you use in cell C8 is:
=IF(OR(B8="Adelaide",B8="Mackay",B8="Katherine",B8="Darwin"),3,"")
that I suggested that you use in cell C8 is:
=IF(OR(B8="Adelaide",B8="Mackay",B8="Katherine",B8="Darwin"),3,"")
J
JE McGimpsey
One way:
=IF(SUM(COUNTIF(B8,{"Adelaide","mackay","katherine","darwin"})),3,"")
=IF(SUM(COUNTIF(B8,{"Adelaide","mackay","katherine","darwin"})),3,"")