• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

testing the same cell with other cells

Thanks but it's giving an error. This is the formula I typed in. Where's the error ?

=IF(G1236>=J1236<I1236,"data2","data1")
 
I'm not entering the formula in G1236. I'm entering it in a different cell ( M1236 ) and I want it to say " data 2 " if G1236 is bigger or equal to J1236 and smaller than I1236.
 
Back
Top