Cell Formulas

[boakley]

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!

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)

 

[Fluff]

What formula do you have in col C?

 

[Joe4]

It sounds like your issue may actually be the formula in cell C3.
It should be:

=B3*.15

If B3 is empty or zero, it will return zero.

 

[kweaver]

Is this what it should be?

Book1
	A	B	C	D
3	Product A	100	15	115
4	Product C		0	0
Sheet10

Cell Formulas
Range	Formula
C3:C4	C3	=B3*15%
D3:D4	D3	=B3+C3

 

[boakley]

It sounds like your issue may actually be the formula in cell C3.
It should be:

=B3*.15

If B3 is empty or zero, it will return zero.

That was it! Thank you so much!!

 

[Joe4]

You are welcome.