| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula help
how would i write say
if B8=Adelaide or mackay or katherine or darwin then c8 = 3 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula help
-- Kevin Backmann "pezacide" wrote: how would i write say if B8=Adelaide or mackay or katherine or darwin then c8 = 3 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
