If cell contains x, then return a value

[harky]

Possible to do?
If vendor AP, 1box = $1, if AM1Box = $2

i had few box size with diff price.

the formula will be at Column C based on Column A

or should use match?

BP_Actual Qty & Costs_2021 (as @ 14Oct21).xlsx
	A	B	C
1	1 box	Vendor	1 box
2	1	AP	$ 1.00
3	2	AM	$ 4.00
4	10	AP	$ 10.00
Sheet1

 

[RoryA]

Do you mean:

=A2*IF(B2="AP",1,2)

 

[harky]

Do you mean:

=A2*IF(B2="AP",1,2)

dont think is correct?

the formula will put at column C

so

if vendor is AP, C will auto calculate the total price based on Column A (1 Box for AP is $1)
if vendor is AM, C will auto calculate the total price based on Column A (1 Box for AM is $2)

 

[RoryA]

So how is the formula wrong?

 

[harky]

So how is the formula wrong?

the Column B can be AP or AM.. depend what user put

 

[harky]

Data list

BP_Actual Qty & Costs_2021 (as @ 14Oct21).xlsx
	A	B	C	D	E
1	1 box	2 Box	Vendor (AM or AP)	1 box	2 Box
2	1	0	AP	$ 1.00
3	2	0	AM	$ 4.00
4		5	AP		$ 15.00
Sheet1

This is my unit price

BP_Actual Qty & Costs_2021 (as @ 14Oct21).xlsx
	J	K	L
2		Unit Price
3		AM	AP
4	1 box	$ 1.00	$ 2.00
5	2 Box	$ 2.00	$ 4.00
6	3 Box	$ 3.00	$ 6.00
Sheet1

 

[jtakw]

Hi,

Did you actually try RoryA 's formula?
If you try the formula, you'll see it calculates as you described.

 

[harky]

Hi,

Did you actually try RoryA 's formula?
If you try the formula, you'll see it calculates as you described.

i try.. but it wont work if i had more than 3..

Mean AP AM or other...