ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   versions / scenarioes (https://www.excelbanter.com/excel-worksheet-functions/125251-versions-scenarioes.html)

Mark

versions / scenarioes
 
Hi.

In Lotus 1-2-3 (remember that?), you could have versions of ranges, and in
those versions, you could have totally different information.

Does Excel have anything similar? I've looked at scenarios, but it appears
that only constants can be stored in the changing cells for scenarios, not
formulas?

Is there anyway to store different formulas in the cells that change for
different scenarios?

Mark


All times are GMT +1. The time now is 09:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com