Excel OOT (Out of Tolerance) Formula

[ARivers]

*Moderator - Please move if thread belongs elsewhere

Hello all, I am new to this forum which was recommended by Robert Howard at Carolina Metrology.

I have lost some of my what once was limited knowledge of Excel formulas. I am attempting to make a column for Out of Tolerance features that only shows how much the feature is out of tolerance if it is out of tolerance and is left blank if the feature is in tolerance. I have an example attached. In my example I used three formulas in three columns to achieve my goal but I know there is a way to do this fx in on column. If someone could help me that would be great. The three formulas in the three columns I used are below. Thanks in advance!

=IF(J2<H2,J2-H2,"")
=IF(J2>I2,J2-I2,"")
=IF(K2<>"",K2,L2)

 

[Miner]

Try nesting the IF() statements.

 

[Michael_M]

Review the following image. this is a fairly quick code but it gives you something to start with.

 

[ARivers]

Nested IF Function got me there:

=IF(J2<H2,J2-H2,IF(J2>I2,J2-I2,""))

Thanks!