Results 1 to 5 of 5

lotus formula to excel formula conversion

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-18-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    161

    lotus formula to excel formula conversion

    I have a huge lotus workbook that i have been working on converting to excel. Just so nobody thinks i am trying to get someone else to do my work , i have about 30 hrs of time in it so far and have had success converting about 95% of the formulas that needed correcting ( some bigger than these two i need help with) . for some reason i can't get the syntax right on these two formulas no matter how much i work at it. could somebody offer any assistance . I have attached the file that i am working on. i colored the two cells with the formulas i need help with (red). also if you look at Cell M10 (colored orange) you can see where i have been working on the formula and have made some progress.

    In the cells that need the formulas converted :
    the values that should show up if the formulas are correct.

    F22 = 0
    F25 = 29.0

    Thanks so much ,
    Attached Files Attached Files
    Last edited by Traymond; 11-25-2010 at 02:51 PM.

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