Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. crazybird

    Lotus 123 Rel. 5.0 Formula

    If there are no duplicates in your number list, then you can try: @SMALL($A$1..$A$9,1)+@SMALL($A$1..$A$9,2)+@SMALL($A$1..$A$9,3)+@SMALL($A$1..$A$9,4)+@SMALL($A$1..$A$9,5) If you organize your list of numbers in a column with a text header, then you can use a much simpler formula...
  2. crazybird

    Counting occurences of data

    This is one type of task that Excel can do much better (using an array formula). Method 1 If I needed to do this task, I would be a /Data Query Unique. In R5, after doing this, the formula @info("dbrecordcount") would hold the value of the number of items extracted, which would be the value...
  3. crazybird

    Counting occurences of data

    Sorry! The suggestion above does NOT work. If get another (hopefully better) idea, I'll revert.
  4. crazybird

    Counting occurences of data

    I think this might work, but I haven't exhaustively tested it: @RANK(@MIN(A2..A6),A2..A6)-@RANK(@MAX(A2..A6),A2..A6) where your number occupy the range A2..A6.
  5. crazybird

    Excel formulas in 123

    @if works this way: @if([condition];[do this];[else do that]) [condition] must be either true (not equal to zero) or false (zero). example using AND: @if(A1=B1#and#C1=D1;A4;0)
  6. crazybird

    Excel formulas in 123

    OK. How about this?: @IF(@isempty(F5)#OR#@isempty(H5)#OR#@isempty(I5),"",F5+H5-I5)
  7. crazybird

    Excel formulas in 123

    @IF((F5="")#OR#(H5="")#OR#(I5=""),"",F5+H5-I5) Here is the version that is equivalent. You have some displaced perenthesis in your version. Does this help?
  8. crazybird

    Converting decimals to quarter-hours in Lotus 123 97

    The solution is: @ROUNDM(A1,0.25)
  9. crazybird

    Skipping Data in 1-2-3 Chart

    Try putting @NA on the missing data points.
  10. crazybird

    Lotus Formula Syntax?

    Every formula must begin with one of these: + - @ function ( or any number You don't commence with the = sign. The expression @SUM(Al:C3) should be @SUM(A1..C3)
  11. crazybird

    Lotusscript - simple 123 automation - getting started

    I recommend appending the new data to your account database using {DATABASE-APPEND}. You can also just use {APPENDBELOW} or {APPENDRIGHT}.
  12. crazybird

    COPY VALUE ONLY

    I would use {RANGE-VALUE destination;[origin]} which is equivalent to the classic /RV but behaves a little better using R9.x .
  13. crazybird

    1-2-3 Macro using only half of processor

    I don't know the direct solution to your problem, but I'd love to know what a macro that runs for days does and how it does it. I'd like to think that such a process could be simplified. (I'd be willing to try.)
  14. crazybird

    Returning the name of a worksheet in 123

    @cellpointer("sheetname") or @cellpointer("sheet")
  15. crazybird

    Old 123 Macro command query

    I still use R5 which has this ":" menu, although I never use it. (R5 has 3 menu systems!) You'd have to resort to an old manual for DOS versions 2.3 or greater to get the info. (Books on R5 ignore the WYSIWYG menu.)
  16. crazybird

    Old 123 Macro command query

    The macro uses the old WYSIWYG menu, which is used for formatting. :flb font-lines-botton :FF2 format-font arial mt14 :FBS font-bold-set :sc special-copy (copies formatting) :wrs worksheet-row-set height :FCBN format-color-background normal
  17. crazybird

    Lotus 123 reservation

    If your file is a true utility and no data is being preserved with each access, then have the opened event change the file name upon opening the file. Here is a macro version. A script should be similar: \0 {FOR x;1;9999;1;testFname} {FILE-SAVE fName} x 112 fName file0112.wk4 testFname...
  18. crazybird

    Writing Formulas for Lotus 123 Release 5

    With R5 you'll need to use @DCOUNT. You'll have to insert a row at A1 with a label, say "VALUES". Then you can just do: @DCOUNT(A1..A21;0;A2>3.49)
  19. crazybird

    NEED TO CONVERT PRINT MACRO FROM DOS TO VERSION 9

    You can convert the macro from DOS to Windows. This can get you started: {EDIT-GOTO A1} {WINDOWSOFF}{PANELOFF} {GET-LABEL "When the printer is ready press [ENTER] to proceed ",ANSWER} {INDICATE Printing file} {SET "Printer-Setup-Name";"PrinterName"} {SELECT B1} {END}{SELECT-DOWN} {SELECT-RIGHT...
  20. crazybird

    Detecting if cancel key is pressed in ALERT command

    You should be able to adapt my previous macro for use with get label by studying the online help for that command (in R5) which I'm copying in below: {GET-LABEL [prompt];result;[default];[title];[x];[y]} Lets the user enter anything that you want 1-2-3 to store in the worksheet as a label. ·...

Part and Inventory Search

Back
Top