Skip, thank you very much! I really struggled with getting these formulas right so I did it the long way. I have realized I am way behind on my Excel formulas. When I joined here in 2002, I was a lot better but time flies and I moved on to other careers. This really helps, thanks!
Our city utility water rates are outrageous and I am trying to do the formulas to calculate the bill and then compare them to historic bills and water rates from other towns.
1st 2,000 gallons are $21.61, after that the rates are tiered, 2001 to 10,000 gallons are $6.11 etc.
I used 21,000...
In a Excel company timesheet, salary employees get an "X" for daily work or a "V" for vacation. What formula can be used to convert X to equal 8 so it can be summed for weekly and bi-weekly totals?. Right now the supurvisor manually enters the total for salary employees and then has a sum...
I had set up a database in Access 2000. I set it up with relational tables, 1 for the job information and 1 for the clients in the job, the job # is the link to the tables. I made a form that combined the information in the 2 tables with a query to perform math calculations and get payment...
I know you posted here several months ago but here is what I did to get PhotoDraw 2000 to work in XP. Install PhotoDraw, get all the online Office 2000 Service Pack updates (SP1a, SP2, & SP3)(See link below) and install them. Then change compatability mode on PHOTODRW.EXE to Windows 98. That...
Well, bcastner, you are great. I tried it and it works great now. It took me less than 30 minutes to fix this and I had been working on it for 15 hours and had no solution in sight. Thanks again.
Can anyone help me with this?
Have a Windows 98 computer with a cable modem, got an XP computer in addition to the 98 computer. Bought a router and hooked them both up to the internet, this worked fine and they networked with each other fine. THEN the 98 computer got the "Wsup, WToolsA"...
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.