![]() Note: You MUST specify the match criteria for VLOOKUP to exactly retrieve correct rates. VLOOKUP uses the exact match criteria to retrieve the exchange rates in Column 2 of the exchange rate table ($F$2:$G$8). ![]() ![]() This is not only hard to understand but will definitely slow down your worksheet.īelow VLOOKUP Function is the 1st Alternative. The first step would be to look up the exchange rate per currency. Say you have below price list with mixed currency and you want to convert them to USD You don’t need to slow or complicate your worksheet anymore, here are the 7 faster alternatives: However, it is also one of the most misused functions, especially Nested IF.Įspecially now with Excel 2007 and beyond, you can nest up to 64 IF functions to form complex, slow and hard-to-understand IF THEN ELSE statement. In my opinion, it is the foundation of all programming and Excel formulae mastery. IF function is one of the most used functions in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |