Start fresh with Microsoft 365

Dynamic Currency Exchange Rates on Income Statement in Microsoft #Excel 365 & #GoogleSheets Excel 365: =STOCKHISTORY(P10,TODAY()-1,TODAY(),0,0,1) Google Sheets: =GOOGLEFINANCE("USDEUR") OR =IFERROR(GOOGLEFINANCE(C3),"") Data Validation & =XLOOKUP($D$7,$O$10:$O$14,$Q$10:$Q$14,"") =IF($D$7="PKR", I9,I9/XLOOKUP($D$7, $O$10:$O$14,$Q$10:$Q$14,"")) DISCLAIMER: Financial market information is provided "as-is" and not for professional or trading purposes or advice. | Excel Basement

Microsoft 365 - Learn how to empower dynamic teams and...

Microsoft 365 - Learn problem-solving approaches to...

Learn How to Collaborate Using Office 365 Online