+ Reply to Thread
Results 1 to 5 of 5

Excel Equivalent to Lotus 123 Formula

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    5

    Excel Equivalent to Lotus 123 Formula

    I am converting some old Lotus123 files to Excel.

    I have three columns Sequence, Month, Cost. I wish to recover the Cost number in a fourth column.

    The "Month" column formula in Lotus is: +MONTH="Jan"#OR#MONTH="Feb"#OR#MONTH="March"#OR#MONTH="Apr"#OR#MONTH="May"#OR#MONTH="June"#OR#MONTH="July"#OR#MONTH="Aug"#OR#MONTH="Sept"#OR#MONTH="Oct"#OR#MONTH="Nov"#OR#MONTH="Dec"

    How do I get to the Excel equivalent to this formula?

    Thanks for your help.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel Equivalent to Lotus 123 Formula

    Maybe

    =OR(MONTH="Jan", MONTH="Feb", MONTH="March", ..., MONTH="Dec")
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    11-08-2011
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel Equivalent to Lotus 123 Formula

    Unfortunately that did not work.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel Equivalent to Lotus 123 Formula

    Post a workbook.

  5. #5
    Registered User
    Join Date
    11-08-2011
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Excel Equivalent to Lotus 123 Formula

    As requested, attached is a sample workbook. The original is rather large. I hope this helps to come up with a solution. Thanks for your help.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1