Hello - I am not sure how I can add the below if statement into what I already have below. Any ideas?
=IF(AND(H9="USD",E9="USD"),"No FX Trade Needed",IF(OR(H9="",E9=""),"",IF(H9=E9,"BUY","SELL"))))
What I want to add is IF cell A1 and B1 start with "US" then cell H1 needs to be USD, "flag for exception". Or if cell H1 doesnt equal USD, "flag for deletion"?
Thanks!
=IF(AND(H9="USD",E9="USD"),"No FX Trade Needed",IF(OR(H9="",E9=""),"",IF(H9=E9,"BUY","SELL"))))
What I want to add is IF cell A1 and B1 start with "US" then cell H1 needs to be USD, "flag for exception". Or if cell H1 doesnt equal USD, "flag for deletion"?
Thanks!