yogi_Create Logs For Items And Dates Based On Table In Rates Sheet

Google Spreadsheet   Post  #2168

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-25-2017

question by MiVoJa:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/H4RpTB55UpM;context-place=forum/docs

What's the best array formula for converting different currency?
Hi,

I'm trying to convert different currencies. What is the best formula if I'd like to place it on the top cell. I'm thinking of placing it on Rate tab - D1

Please see my sheet: https://docs.google.com/spreadsheets/d/1b8SaycW_sMGvbOUkBlfRhO5AoA46ewvTnztnjgZXN98/edit?usp=drivesdk