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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Joe4

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

Watch MrExcel Video

Forum statistics

Threads
1,114,336
Messages
5,547,345
Members
410,785
Latest member
phillippaige
Top