Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]



Some possible options are:


1)       Use Goal Seek

2)       Use Solver

3)       Look up help for  what if analysis, and scenarios (I cannot remember how this works, but it allows generating a table of values for a function: the function only needs defining in one cell.)

4)       Write a VBA function: Tools/Macro/VBA editor


You may have to include the analysis toolpack add-in, if not already installed.



Conrad Harrison

B.Tech (mfg & mech), MIIE, gradTIEAust



South Australia