I need to help to set IF formula

[santoshchudappa]

Hi Good afternoon,

I need to help to set IF formula, as If column A2 = VRL then formula will =IF(A2="VRL",((B2*C2*D2)/1728)*10), Now same result I needed If Column A2=FedEX then formula should be =IF(A2="VRL",((B2*C2*D2)/1728)*8) and If Column A2=DHL then formula should be =IF(A2="VRL",((B2*C2*D2)/1728)*5), So that I will get appropriate answer after once I change courier name in Column A2

 

[Alex Blakenburg]

You can use an If statement but I think you would be better off with a lookup table.
(In the below my Excel Table for the courier is called tblCourier, it can be placed anywhere in the current WorkBook)

20210706 IF change to vlookup.xlsx
	A	B	C	D	E	F
1	Select Courier	W	B	H	Result
2	VRL	20	18	12	25
3
4
5
6
7
8
9
10	Table --> tblCourier -->		Courier	Multiplier
11			VRL	10
12			FedEx	8
13			DHL	5
14
Data

Cell Formulas
Range	Formula
E2	E2	=(B2*C2*D2*VLOOKUP($A$2,tblCourier,2,FALSE))/1728

 

[Snakehips]

@santoshchudappa Maybe, try this.

=B2*C2*D2/1728*(LOOKUP(A2,{"DHL","FedEX","VRL"},{5,8,10}))

 

[santoshchudappa]

Thanks a lot Alex Blakenburg and Snakehips for helping me out to resolve this issue.

Big Thanks!

 

[Alex Blakenburg]

Glad we could help. Thanks for the feedback.