Forum Discussion

Joe Flores's avatar
Joe Flores
Copper Contributor
Feb 18, 2018

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.

 

Macros & VBA
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 19, 2018

    Joe,

     

    What you asked for isn't macro, it's formula!

    Please tell us what are you trying to do?

    In Lotus 1-2-3, what is the use of this symbol &?

  • Keith Perry's avatar
    Keith Perry
    Copper Contributor
    Feb 21, 2018

    I think you might be able to use the AND:  =IF(AND(F105 = "MT",J105="USA"),"USA","") ?

     

     

     

Resources