formula help
 

how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3

formula help
 

--
Kevin Backmann


"pezacide" wrote:

how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3

formula help
 

In C8
=IF(OR(B8="Adelaide",B8="mackay",B8="darwin"),3,)
Regards,
Alan.
"pezacide" wrote in message
...
how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3

formula help
 

Enter this formula in C8:

=IF(OR(B8={"Adelaide","Mackay","Katherine","Darwin "}),3,"")

--
Biff
Microsoft Excel MVP


"pezacide" wrote in message
...
how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3

formula help
 

sorry kevin i dont get your answer does -- mean or.


"Kevin B" wrote:


--
Kevin Backmann


"pezacide" wrote:

how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3

formula help
 

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,"")
--
Kevin Backmann


"pezacide" wrote:

sorry kevin i dont get your answer does -- mean or.


"Kevin B" wrote:


--
Kevin Backmann


"pezacide" wrote:

how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3

formula help
 

One way:

=IF(SUM(COUNTIF(B8,{"Adelaide","mackay","katherine ","darwin"})),3,"")

In article ,
pezacide wrote:

how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3