Reflash if or

makinmomb

Active Member
Joined
Dec 23, 2013
Messages
401
Formula on c29

if b6 is KASUMBALESA or LUBUMBASHI
then plug fare as 480,000
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,836
Office Version
  1. 365
Platform
  1. Windows
Your question is a bit lacking in detail, but perhaps:
Code:
=IF(OR(B6="[COLOR=#333333]KASUMBALESA",B6="[/COLOR][COLOR=#333333]LUBUMBASHI"),480000,"")
[/COLOR]
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,836
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,112,942
Messages
5,543,126
Members
410,583
Latest member
jgalin
Top