Results 1 to 3 of 3
  1. #1
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Array Formulas in Lotus (2000)

    You may recall my recent post re secure models for distribution. Well I am now experimenting with Visual Baler which requires the file format to be a Lotus .wk4. The model I am trialling has an array formua to sum a series of rows that multiples price times parts per hundred.
    This array formula does not convert in .wk4, and as it must be almost 10 years since I used Lotus does anyone know what the Lotus equivalent of the following array formula would be?
    {=SUM($B3:$B15*$E3:$E15)}
    If there is no eay equivalent then I will have to change the model to create an intermediate step.
    Paul Coyle
    Approach love and cooking with reckless abandon

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Array Formulas in Lotus (2000)

    Hi Paul,

    Whilst I don't know the Lotus equivalent, you could try developing a non-array equivalent in Excel and saving it in the wk4 format. For example, you could use SUMPRODUCT in a std non-array format if lotus supports that.

    Just a thought ...
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    4 Star Lounger pccoyle's Avatar
    Join Date
    Apr 2001
    Location
    Auckland, Auckland, New Zealand
    Posts
    535
    Thanks
    3
    Thanked 2 Times in 2 Posts

    Re: Array Formulas in Lotus (2000)

    Thanks Macropod, you are right, and I have further experimented today so can now replicate the input sheet interactivity in Visual Baler. So progress is being made.
    Once all the Excel sheets are changed I can start getting a handle on how this Visual Baler operates to distribute secure executables.
    OH, the places you'll go (title of a Dr Seuss book) <img src=/S/thumbup.gif border=0 alt=thumbup width=15 height=15> <img src=/S/flags/NewZealand.gif border=0 alt=NewZealand width=30 height=18>
    Paul Coyle
    Approach love and cooking with reckless abandon

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •