The Excel cell formula below calculates the nearest standard 1%-resistor value without using a lookup table or macro. Type or electronically paste the text below into any cell (other than A1). The ...
The value of the resistor is 64.3K ohms. The tolerance is ±5% and the tempco is 25 ppm/°C. The first 4 bands determine the value, the fifth band is the tolerance, and the 6th band is the tempco.