Electrical Engineering With Excel - Engineering Prefix Function for Excel NEW (4k Video)

Welcome to Electrical Engineering with Excel. Several years ago, I developed some Visual Basic for Applications Code, for a User Defined Function, that would take in a number, and return a text version, scaled to the appropriate engineering prefix level, with the SI prefix appended. I then wrote similar code, to do the same for capacitor values, since they rarely use the SI prefixes nano and milli. I have now decided to consolidate both of those features, into one User Defined Function. The VBA Code is available with a link in the description. Link to VBA Code https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/c05174caf75cf1e4d97e00c071c801b6684abeea/VBA%20Code%20-%20ENGPREFIX%20Function.txt Syntax https://github.com/oldhackEE/Electrical-Engineering-With-Excel/blob/c05174caf75cf1e4d97e00c071c801b6684abeea/ENGPREFIX%20Syntax.pdf 00:00 Intro 02:40 SI Units 06:24 Using Log Base 1000 09:36 Visual Basic LOG Function is Base "e"!! 12:12 Capacitors Rarely Nano Rarely Milli 13:12 Syntax 15:30 Spaces & Rounding 17:17 Arguments 21:02 Visual Basic Coding Correction: 8:58 Should be 1.432 not 1.434