Currency Conversions

Hi all,

Question on how to set this up.

I have one Column containing Executive Compensation in Israeli Sheikels per month. I want to type in a formula to convert those figures to USD per year.

The current conversion rate for Shekels to dollars is 0.24834US Dollar per Israeli New Shekel This exchange rate is based on the daily rates for the US dollar.

What would the formula be?

Thanks!

If the Israeli amount is in A1, and the conversion rate is in B1, then

Please Login or Register  to view this content.

should give the proper result

Edit:

Actually, go with

Please Login or Register  to view this content.