By Christine Schneider, January 21, 2002
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 formula will calculate the nearest 1%-resistor for the...