Excel V Lotus 123

  • Thread starter Thread starter Taffy
  • Start date Start date
T

Taffy

Hi,
I believe that in Lotus 123 there was a "Version" option, just like the
Version option when creating MS Word Files. Is there anything similar
in Excel 2000 or higher. Scenarios won't work because there are too
many changing Cells. Also, Lotus 123 had a "Weighted Average" Function
- is there anything similar in Excel.
Any help would be greatly appreciated.

Many thanks,
Taffy
 
Answer to second part: roll your own with SUMPRODUCT
Let A1:A10 contain the frequency values (weights) and B1:B10 the values to
be averaged, then weighted average is given by
= SUMPRODUCT(A1:A10, B1:B10)/SUM(A1:A10)
best wishes
 
Excel doesn't have a Versions option. You can save different versions of
the workbook manually. Or, if there are fewer than 256 scenarios, or
changing cells, you could use the scenario alternative shown here:

http://www.contextures.com/excelfiles.html

Under Scenarios, look for Alternative to Scenario
 
Back
Top