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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Joe4

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

Watch MrExcel Video

Forum statistics

Threads
1,109,451
Messages
5,528,834
Members
409,839
Latest member
akashsadhu
Top