Add agrument to formula

[jlyn123]

=IF(AND(H14="USD",E14="USD"),"No FX Trade Needed",IF(H14=E14,"BUY", "SELL"))

How can I add a new agrument to this statement? If fields H and E are left blank I dont want the value to be returned as "BUY" I would like it to be blank. I tried added IF(H13="","") but I get error messages. There are a lot of currency related to the BUY and SELL options and I dont want to have to list them all out.

Any help would be greatly appreciated.

Thanks!

 

[Joe4]

What if only one of H14 and E14 are blank?
What should happen then?

If you want nothing to be returned if EITHER of them are blank, try:

[COLOR=#333333]=IF(AND(H14="USD",E14="USD"),"No FX Trade Needed",IF(OR(H14="",E14=""),"",IF(H14=E14,"BUY", "SELL")))[/COLOR]

 

[jlyn123]

This is exactly what I needed. Thank you!

 

[Joe4]

You are welcome!