Hello all!
I have a job material list that use for work. In column A, I inout the description of the materials.
Column B is the price I paid for the material
Column C is 15% of the corresponding column B cell for a mark up in price
Column D is the sum of column B and Column C.
When no data is entered for column B, the totals for column C turns to $.15 even though Column B is “0.00”. I need that .15 to not be there because it throws my totals off. Please help. Mini Sheet is below. Thank you in advance!
I have a job material list that use for work. In column A, I inout the description of the materials.
Column B is the price I paid for the material
Column C is 15% of the corresponding column B cell for a mark up in price
Column D is the sum of column B and Column C.
When no data is entered for column B, the totals for column C turns to $.15 even though Column B is “0.00”. I need that .15 to not be there because it throws my totals off. Please help. Mini Sheet is below. Thank you in advance!
Job Materials.xlsx | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Job Materials | |||||||
2 | Description | Price Paid | Mark Up | Total | Total Paid | Total To Bill | ||
3 | $0.00 | $0.00 | $0.00 | |||||
Sheet3 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D3 | D3 | =SUM(B3,C3) |
E3 | E3 | =SUM(B3:B100) |
F3 | F3 | =SUM(D3:D100) |