formula help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3
 
Enter this formula in C8:

=IF(OR(B8={"Adelaide","Mackay","Katherine","Darwin"}),3,"")
 
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,"")
 
One way:

=IF(SUM(COUNTIF(B8,{"Adelaide","mackay","katherine","darwin"})),3,"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for showing warnings when cells are out of range. 1
Drag formula problem 2
using colour within a formula 5
LOOOONG if statement out of room, need help to shorten 4
how would I write a formula 7
Sumproduct formula problem 5
How can Excel generate more decimal points ie 5.5% not 5% 2
A different kind of VLookup 8

Back
Top