I am using Execl 2013
I want to test 2 cells in another tab as below, esseentailly I want to test between +- 3%
=IF('FX History Paste'!D60>0.03,"Large Move","OK")
=IF('FX History Paste'!D59<-0.03,"Large Move","OK")
BUT how do combine the 2 tests so output is in one cell only
I want to test 2 cells in another tab as below, esseentailly I want to test between +- 3%
=IF('FX History Paste'!D60>0.03,"Large Move","OK")
=IF('FX History Paste'!D59<-0.03,"Large Move","OK")
BUT how do combine the 2 tests so output is in one cell only