Crazybird
Sorry I didn't get to this sooner, I have the test sheet at work and just got to try it this morning.
I tried the formula (the first one) and it works great. It also may surprise you to know that duplicate numbers do not mess up the formula. I tried it all different ways, did it on a...
I'm trying to find a formula that will add the lowest 5 numbers out of 10. I have a formula that will delete one of the high numbers out of 10 but can't seem to figure out how to count the lowest 5 and ignore the highest 5. That formula I'm talking about is @sum(A1..A10)-@MAX(A1..A10).
I found...
I aggree with you that the "1" should not be in front of the @ sign, but can't explain why it is. I have an old book that explains the @FV formula this way:
@FV(payment, interest, term)
The @FV function calculates the future value of a series of equal payments, where "interest" is the interest...
It's a common problem with Lotus release 4 & 5 with XP. I found it myself on this forum after searching for 6 months or more. You just go to your desktop, right click and select properties, go to the "appearance" tab, click on the "settings" button near the bottom and UNCHECK the first one which...
I had the same problem after upgrading an older laptop to Win 98 SE. The fix was to download a supplemnet from microsoft named 4756US8.exe. You can search for it in the support section, it's an updatge to coreect shutdown problems in Win 98SE. Disable your Anti Virus before running.
You will need to download from Microsoft a Win 98Se Supplement, it's called 4756US8.exe. Disable your anti-virus before running it. I have it on a floppy if you want me to email it to you.
There is a Windows 98 SE Shutdown Supplement you can dowload for this problem, it cured an old Laptop of mine instantly. You will find it here:http://www.microsoft.com/windows98/downloads/contents/wurecommended/s_wufeatured/win98se/default.asp
I have been using Lotus 123 Rel. 4.01 & 5 for years now but the only problem I have is sending a speadsheet via email. When I click on the icon to send by electronic mail I get a Mail System Error. I am using Outlook Express as my default mail program. The book I have shows how to modify the...
I had some problems with my niece's NEC Ready 9909 PC which is also a Packard Bell. I emailed NEC who replied and said they do not offer any support for those anymore but directed me to a website with a lot of Q and A's regarding Packard Bell PC's. Try also looking into...
After reading through some other FAQ's regarding Release 5 I found others were having the same problem with the color palette. I tried the fix mentioned in other threads and it fixed my version 4.01.
It amounted to right clicking the desktop, properties, appearance tab, effects, disable the...
I was having the same problem with my Lotus 123 version 4.01 after finding this thread it fixed mine also.
Thanks, I have been looking for this fix for months.
I have been using this program since it was first released and have continued with it finding it better than the newer versions. Originally when I wanted to change font or background color a pop-up color palette would appear on screen. Now I only get a blinking little square with nothing in it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.