View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
 
Posts: 989
Default 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