| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |
|
|
Hybrid Mode
