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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,929
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,929
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,528
Messages
5,548,571
Members
410,852
Latest member
WernerS
Top