•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.
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]
Want to read more?
Check out the full article on the original site
Tagged with
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#IF function
#total inventory value
#currency conversion
#CAD
#USD
#purchase history
#purchase price
#formula
#Excel
#analyze
#copy value
#data analysis