Windows 10: Lotus 123

I'm successfully running 123 on w10 but also use excel.


1) Is there a similar function to sumifs in 123?

2) Is there a help out there that lists ALL 123 functions with examples? The help in my 123 doesn't work!

3) I can't remember how to express the >= in following equation: @SUMIF($AU$2..BF$2,BR1,$AU6..BF6) which correctly allows me to sum the range AU6- BF6 IF AU2-BF2 is EQUAL to the contents of BR1 but I want it to SUM all that's GREATER or EQUAL. Tried following two different ways of expressing formulae but doesn't work:

@SUMIF($AU$2..BF$2,>=BR1,$AU6..BF6) and @SUMIF($AU$2..BF$2,">="BR1,$AU6..BF6).

I do know that if I embed the actual contents (ie 'xxx') of BR1 in the formula then it works like this:

@SUMIF($AU$2..BF$2,">=xxx",$AU6..BF6)


I'm missing something simple! Can anyone help?

:)

 

Lotus 123 Version 9.8 and Windows 10 - Will Lotus 123 load and run?

Has anyone tried or been able to load Lotus 123, version 9.8 on a Windows 10 laptop?

My current Toshiba laptop with Windows 8.1, loaded and runs Lotus 123, (Original IBM SmartSuite version 9.8 install CD). I don't want to upgrade it to Windows 10 unless Lotus 123 will still run on it. I have hundreds of spreadsheet programs written in
Lotus 123 and hate to lose them. I do all my current financial and budget spreadsheet in Lotus 123, and use special print macros to make them fit on one page with minimal margins.

Any help or comments would be appreciated. Thanks, Lynn.

 

Lotus 123 Version 9.8 and Windows 10 - Will Lotus 123 load and run?

I have been able to load and run IBM Lotus 123, version 9.8 on my Dad's new Windows 10 laptop. I did not try to load the entire Lotus Suite, as we only wanted Lotus 123. It works great!

 

Lotus 123 Version 9.8 and Windows 10 - Will Lotus 123 load and run?

My Smartsuite 97 disk would not autoload but when I browsed to folder "English" and found and clicked on setup.exe it installed with no problem. Beforehand I had been trying compatibility settings and had chosen 'worked on version XP'. Now I have my old
friend Lotus 123 working happily on my Win 10 machine.