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

Below you see 2 examples and for the last one the according formulas:

A B C D E
F G
Item Description Cost Tax Cost+Tax Sell Install.Time
1 Item 1 15 1.24 16.24 55.74 0.5
2 Item 2 18 1.49 19.49 137.99 1.5
2 Item 2 18
Formula in cell
D E F
Value in cell G
=ROUND(C3*0.0825;2) =C3+D3 =E3+79*G3 1.5

regards
reklamo




"greenscove" wrote:

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