•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
IF calculation question: If currency is CAD, then *.73 to convert to USD, if currency is USD, then copy number.
Our take
Hello, Daniel! To calculate the total inventory value in USD based on your purchase history, you can enhance your IF function to accommodate both currency scenarios. The formula you need is: `=IF(L5="CAD", K5*0.73, K5)`. This setup will multiply the value in Column K by 0.73 when the currency in Column L is CAD, while it will simply copy the value when the currency is in USD. By using this formula, you can efficiently analyze your inventory value in USD without any confusion.
Hello,
I'm trying to get a total inventory value for my department by analyzing purchase history. Purchases have either been made in CAD or USD. I want total inventory value in USD.
Column K shows the purchase price and Column L shows whether it was in CAD or USD.
How do I set up an IF function so that if L5 is CAD, multiply K5 value by .73, but if it's USD, then don't do anything and copy the value over? Does that make sense?
I can do the IF(L5="CAD",K5*0.73) portion of the formula, but I'm struggling to add another command to the same formula.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience