Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel Formula For Utility Water Billing
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!- esb6
- Post #3
- Forum: Microsoft: Office
-
Excel Formula For Utility Water Billing
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...- esb6
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
Excel Formula Help In Timesheet
Thanks, anotherhiggins, that works great also!- esb6
- Post #6
- Forum: Microsoft: Office
-
Excel Formula Help In Timesheet
Thanks Skip. Worked great! I haven't had an excel class since 2000 so I am rusty.- esb6
- Post #4
- Forum: Microsoft: Office
-
Excel Formula Help In Timesheet
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...- esb6
- Thread
- Replies: 6
- Forum: Microsoft: Office
-
Mail Merge Letters Don't Work in Access 2003
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...- esb6
- Thread
- Replies: 0
- Forum: Microsoft: Access Other topics
-
Photo Draw 2000
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...- esb6
- Post #4
- Forum: Microsoft: Office
-
Wsup, WToolsa Crashed Internet Connection On Network
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. -
Wsup, WToolsa Crashed Internet Connection On Network
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"...
