Excel V Lotus 123

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
 
B

Bernard Liengme

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
 
D

Debra Dalgleish

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use Lotus 123 comands?; can I format Excel to do so? 3
Converting a Lotus 123 file to Excel 2
How do I open a simple one-page Lotus 123 file in Excel 2007? 3
Exporting Lotus 123 into Excel Work Book? 1
123->Excel 2
Opening Lotus *.123 files in Excel 2
Does Excel have a @grandtotal function like Lotus 123 2
WARNING: Opinion 4

Top