how orginized an calculate error (uncertainty)

[Irv1n]

I want to correctly draw up the calculation of errors for devices, advise how to do it correctly and competently in excel:
We have
Verification point: 200000
Reference: resistance box R40116:
Error:
Low Range. high range. Error Floor
10000 100000 0,0005. 0.025
100000 1000000 0,0002. 0.035
1000000 10000000 0,0002. 0.045
10000000 100000000 0,0005. 0
100000000 10000000000 0,001 0
10000000000 1000000000000 0,002 0

My Verification point in range from (100000 - 1000000) and calculation: 200000*0,0002 +0.035
If Verification point: in range from (10000000000 - 1000000000000) and calculation: verification_point*0.002

Thank!

[GeoffW283]

lookup.png

Enter a value in B1, the result is displayed in B2. The formula in B2 is just a lookup into your provided table. In B2:

Please Login or Register  to view this content.

See the attached workbook