Thread: excel 2000 help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
greenscove greenscove is offline
external usenet poster
 
Posts: 2
Default excel 2000 help

A B C D E F
Item Description Cost Tax C+ Sell
1 Item 15.00 124 123.8 495.0
2 Item
3 Item
4 item 15.00 1.24 16.24 55.74


Line 1 is what I keep getting with my efforts. Not what I am looking to do.

Line 4 is what I would like to see (entered manually).

PROBLEM:
Column C is cost of item
Column D is 8.25% tax
Column E is C+D
Column F is Sell piece+installation charge, which should be E+installation
charge

Column F info:
Installation (Labor) charge is $ 79.00 pr Hr.
Items on parts list take between 1/2 Hr to 1 ½ Hrs to install
Item 1 takes 1/2 Hr
Item 4 takes 1/2 Hr
can anybody help me I am using (Office)Excel 2000
--
greenscove