Hi, everyone.
I'm going nuts - I�m stuck on the syntax for this. I hope my description is clear.
I have numerical data in column F, calculated data (numerical) in column G and this formula goes into column H. The results displayed from this formula are either Yes or No. The conditions are as follows:
1) Which is larger, the data in G or 0.15? The result is the larger value, but this result is not displayed; it is used for #2.
2) Which is larger, the data in F or the ââ?¬Å?larger valueââ?¬Â that was determined in #1? The displayed result will be either Yes (if larger) or No (if not).
Thanks - I'd greatly appreciate any help.
=IF(MAX(G2,0.15)>F2, "Yes", "No")
Thanks for fast response, Chandler. It didn't work though. If I have 0.08 in F2 and 0.07 in G2, the result should be "No", because F2 is less than 0.15. However, I just tried this, and it seems to work:
=IF(AND(F2>0.15,F2>G2),("Yes"),("No"))
How does this look to you? I need to check it to make sure it's working in all scenarios. I also need to read up on the MAX argument; I've never used it.
Thanks again.
Chandler, I stand (actually, I'm sitting) corrected...
The only thing wrong with your formula was the order of the "Yes" and "No". Switch 'em around and much happiness and joy return. I stared at this dang dang thing for so long I thing I was cross-eyed a few times over.
Thanks again.
Glad you got it worked out Jim.
Mark H