A simple currency conversion one I hope!

[chally3]

Hi everyone, Hopefully a simple one for someone but I cannot get it to work!

I’m trying to convert all currencies on a spreadsheet to USD
Column B has the base price, Column C has either (GBP,USD,EUR).

What I am wishing to do is in column D show a USD price only , so if column C says GBP or Euro multiply it by the conversion below , or just copy if its already in USD

GBP to USD = 1.16
EURO to USD = 1.13

Any help appreciated

 

[tyija1995]

Hey chally3,

Use an IF statement to check whether the C column shows GBP or EUR.

E.g. Set cell D1 to the following formula:
=IF(C1="GBP",B1*1.16,IF(C1="EUR",B1*1.13,B1))

 

[Scott T]

Book1
	B	C	D	E	F	G
1					GBP	1.16
2	1	USD	1		EURO	1.13
3	2	GBP	2.32
4	3	EURO	3.39
5	4	USD	4
6	5	EURO	5.65
7	6	USD	6
Sheet1

Cell Formulas
Range	Formula
D2	=IF(C2="usd",B2,IF(C2="GBP",B2*$G$1,IF(C2="euro",B2*$G$2,"not a valid currency abbreviation")))

Copy formula down