Electrical Engineering With Excel - [OBSOLETE] Closest E-Series Preferred Number - User Defined Function

OBSOLETE See: https://youtu.be/XgbEajDoYTc Welcome to electrical engineering with Excel. In the previous video, we wrote some VBA code, to select the closest standard component value, from the E96 series. In this video, we will expand that code, to make it work for the entire group, of E-series preferred numbers, for standard component values. Electrical Engineering Excel E-series Components E series Components Standard Component Value Standard Components Value Download the VBA Code: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/fa21891f0472fbc0c4c85f2b5368210579e77679/E-Series%20User%20Defined%20Function%20Code.txt Download the Spreadsheet: https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/fa21891f0472fbc0c4c85f2b5368210579e77679/E-series%20UDF.xlsm 0:00 Intro 0:33 E96 Code 1:01 Overview of E-Series Exceptions 2:33 E48 - E182 Series 3:04 Writing the Code 4:56 Use in Excel