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 ,
Bookmarks