Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Nested if with a condition - syntax please

Status
Not open for further replies.

mart10

MIS
Nov 2, 2007
394
GB
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
 
great worked a treat, sometimes the syntax aint that obvious
 
mart10, Don't forget to make it official that Deniall's method worked by adding a star. It's one more way for folks to find what works vs what doesn't work.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top