Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
V look up
I am trying to simplify my billing for winter plowing. this is what I am
looking to do Sheet 1 Customer Name in cell A1 / Description of service say plow in cell B1 / # of inches mind you the inches are usually 1-6 6.1-12 which will be in C1 / so in cell D1 I would like the dollar amount. Sheet 2 Plow Plow Plow Salt Calcium Shovel Shovel Shovel Customer 1-6 6.1-12 12.1-18 1-6 6.1-12 12.1-18 Joe Smith $100 $160.00 $240.00 $115.00 $115.00 $115.00 $165.00 $215.00 Tom Smith $70 $120.00 $200.00 $75.00 $80.00 $40.00 $60.00 $80.00 Now these 2 customers are billed by the same inches some customers may be billed 1-4 " 4.1-6" and so on how do i set up my formula to auto pop up my cost for that service one I put into sheet 1. I may not be explaining this very well but need help maybe you can simplify the process -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200911/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|