Hi there,
I have a sheet of data on column J i have a list of prices some in Euro some in GBP with either a £ or €
I have created a new column K and want to covert these all to the same currency of dollar under the rate of use 1.2 for GBP and 1.1 for Euros
Can anyone help me.? I have never used conditional formatting to insert a formula but think this might be the solution?
I have a sheet of data on column J i have a list of prices some in Euro some in GBP with either a £ or €
I have created a new column K and want to covert these all to the same currency of dollar under the rate of use 1.2 for GBP and 1.1 for Euros
Can anyone help me.? I have never used conditional formatting to insert a formula but think this might be the solution?