Euro conversion & IF function

**bobzroom** · 03-27-2008, 05:42 AM

Hi,

Im using a simple product value x quantity x uplift calculation sheet. I am now buying stock in Euros so is there a calculation that would recognise the euro symbol in my calculations??

example

C2 E2
uplift 30% exchange rate 1.277

C5 E5
Nike outlet £ 8.00 Quantity 5
Puma outlet € 9.00

current formula "=C5*E5*(1+C2)" which gives me the cost multiplied by the quantity muliplied by uplift, cool works great but I need it to recognise if the value is in Euros and to add the exchange rate value before doing the rest

If anybody could help with this it would be really appreciated, even if anyone can confirm if the 'if function' recognises currency type?

thanks guys

Brendan

**EdMac** · 03-27-2008, 07:00 AM

Why not have an additional column for currency type? E.G.select Euro or Sterling from a drop down list.

Then you could have an if statement along the lines of

If(your_cell="euro",price_cell*exchange rate,price_cell)

Ed

**bobzroom** · 03-27-2008, 07:34 AM

Thanks Edmac for the reply and yeh I'm trying to use something similar:

=IF(C5="Euro",(C5/G2)*(1+C2),C5*(1+C2)) but Excel won't recognise the 'euro' and I've also tried the '€' symbol also.

Is there a way that Excel will recognise the currency format in a formula?

**EdMac** · 03-27-2008, 08:13 AM

I don't understand the problem. Excel will recognise any text - are you using the word Euro.

Suggest you post a ZIPPED copy of your sheet so I can have a look

Ed

**EdMac** · 03-27-2008, 09:36 AM

bobzroom,

Have a look at the attached - you should be able to adapt the theory to fit your requirements.

Ed

**bobzroom** · 03-28-2008, 05:19 AM

Thanks matey, I think I can use this to help resolve my beef, Im sorry if Im unclear, I have have great difficulty in describing problems at times, my doctor hates me lol

thanks again