Wouldn't that be better?Īnalysis tool pack and Solver add-in has its own functions and formulas, however as an example WORKDAY and NETWORKDAY will work My final questions however is this. Why didn't MS just allow all possible functions seen from add-ins to just be part of the already existing Auto-Formula complete we see in Excel 2007? In other words have an equivalent function for all add-ins in the drop-downĪuto Formula list without having to invoke the Add-In feature. Example of those functions I noticed are WORKDAY and NETWORKDAY. I also noticed certain date and time functions in Excel 2003 which had to be added using add-ins first. The date and time functions seen in Excel 2007 versions onwards now have those functions built into the Auto-Formula complete so we need not do add-insĪnymore.
I'm confused about the choices we see from the Auto-Formula complete and want to know if we load add-ins like Analysis Toolpack, Solver, Lookup Wizard etc will this in any way increase the choices of functions already available from Formula Auto complete? ForĮxample if we load Analysis Toolpack will this add on more functions related to engineering and statistics that's not already listed as engineering and statistics in the Auto-Formula complete list? Or does Add-Ins offer us functions that cannot be found on
0 kommentar(er)
