Forum Discussion
Joe Flores
Feb 18, 2018Copper Contributor
Excel 2016 Macro required
What is wrong with this macro. =IF(F105="MT', & IF(J105="USA", "USA", "")
With lotus I was able to use the & symbol. I need corrected use for this formula.
Keith Perry
Feb 20, 2018Copper Contributor
I think you might be able to use the AND: =IF(AND(F105 = "MT",J105="USA"),"USA","") ?