Hi all I am trying to do something that I am having a hard time figuring out. I have attached a spreadsheet I am creating. Basically it is an Inspection report for a machine shop. I want to be able to enter Dimensions from a Blue print in the first column and based on how many Decimals it has, it will auto fill the tolerance zones upper and lower limits. I was able to get one to work but I can't seem to get the other to work.

My formulas is this:
=IF(B11>".00",B11-I6,B11-I7)
I would like it to read more or less,
=IF(B11=".00",B11-I6,=IF(B11=".000",B11-I7))


Basically, if it is a two place decimal, I want it to subtract the value from I6 and if it is a three place decimal to subtract the value from I7.

Can anyone help please?
Thanks,
Todd

Attached Files

Inspection Sample.xlsx (24.0 KB, 10 views)

Hi

You can determine by the entered decimals in B11 the calculation to be done. Like this:
=IF(LEN(B11)-FIND(".",B11,1)>2,B11-I7,B11-I6)

Thank you! It worked great!

Now, is there a way to add a third line?
So for 1, 2 or 3 decimal places?

This should do it for all, I think.

Lower:
=B11-OFFSET($I$4,LEN(B11)-FIND(".",B11),0)

Upper:
=B11+OFFSET($I$4,LEN(B11)-FIND(".",B11),0)