K
Khalil handal
Hi,
Formula in E6 in sheet3 as follows:
Take the value in D6 in sheet3 with the specific date in A6 (say October 12,
07), multiply it with the corresponding value from sheet2 in range Q4:Q26
with the same date (October 12, 07).
note: Q4:Q26 has the days of month
has to lookup the same date and take the value from sheet2 in onw
of the cells in the mentioned range
Hope this more clear than the previous posting of Yesterday titled:
(exchange rate)
Formula in E6 in sheet3 as follows:
Take the value in D6 in sheet3 with the specific date in A6 (say October 12,
07), multiply it with the corresponding value from sheet2 in range Q4:Q26
with the same date (October 12, 07).
note: Q4:Q26 has the days of month
has to lookup the same date and take the value from sheet2 in onw
of the cells in the mentioned range
Hope this more clear than the previous posting of Yesterday titled:
(exchange rate)