home *** CD-ROM | disk | FTP | other *** search
/ Software Du Jour / SoftwareDuJour.iso / BUSINESS / LOTUS / TUTDOC2.ARC / 4205.PRN < prev    next >
Encoding:
Text File  |  1985-02-26  |  1.1 KB  |  38 lines
  1.  
  2. Problem  Fancy string formulas that take a number like 17,613.05
  3.          and write it out in words like:
  4.  
  5.          Seventeen Thousand, Six Hundred, Thirteen and 05/100 dollars
  6.  
  7.          Handles numbers up to 21000
  8.  
  9.  
  10. Block Diagram
  11.                     ______________ ______________
  12.                    |              |              |
  13.                    |              |              |
  14.                    |   Inputs     |    String    |
  15.                    |   and        |    Lookup    |
  16.                    |   Calcs      |    Tables    |
  17.                    |              |              |
  18.                    |              |              |
  19.                    |              |              |
  20.                    |______________|______________|
  21.  
  22. Tips
  23.          String arithmatic formulas in cells C12..C19
  24.          include @IF, @MOD, @ERR, @VLOOKUP, @S, AND @INT functions.
  25.  
  26.          Time arithmatic formulas (@IF, @HOUR, @STRING, @MOD, @MINUTE,
  27.          and @CHOOSE are used to write out "12:17 in the morning. B6
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.