K
Khalil handal
Hi,
Book1 has 12 sheets for 12 months. Another sheet is named "c_rate" for
currency rates.
Column B has the dates of the month and column C has the excahnge rate for
that day (from $ to NIS).
This is for the twelve months.
In sheet for January at column A, I have dates and they are not assending
order.
What formula should be in cell BU10 (sheet of Jan) so that it reads the date
for cell A10 and multiply the value of exchange rate for that day from sheet
"c_rate" and put it in cell BU11.
Book1 has 12 sheets for 12 months. Another sheet is named "c_rate" for
currency rates.
Column B has the dates of the month and column C has the excahnge rate for
that day (from $ to NIS).
This is for the twelve months.
In sheet for January at column A, I have dates and they are not assending
order.
What formula should be in cell BU10 (sheet of Jan) so that it reads the date
for cell A10 and multiply the value of exchange rate for that day from sheet
"c_rate" and put it in cell BU11.