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, 12 views)