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!