IF statement?

[Nitsalet]

I am sure this is a simple IF statement but it has me stumped.
In Cell J5 I need a formula that will calculate the following:
If the value of Cell E5 is 0, add F5 through H5 and multiply by 1, otherwise add F5 through H5 and multiply by cell E5
I will need to copy this cell down the column so that it applies to the next row.
Any help would be appreciated!

 

[GWteB]

Map1
	E	F	G	H	I	J
5	5	3	9	4		80
Blad1

Cell Formulas
Range	Formula
J5	J5	=IF(E5=0, SUM(F5:H5), SUM(F5:H5)*E5)

 

[jasonb75]

Assuming that E5 is never negative, another way would be

=SUM(F5:H5)*MAX(E5,1)

 

[Nitsalet]

Thanks for your response. However, I need the formula to multiply by 1 if the value in E5 is 0. The formula is going in the Total Qty column in the image below and calculates the total number of shirts in a carton, although sometimes a carton is shared (as in the second row of data).

 

[jasonb75]

However, I need the formula to multiply by 1 if the value in E5 is 0

That is what both suggestions do.

 

[GWteB]

.... and fwiw, multiplying by 1 gives the same result so can be omitted.

 

[Nitsalet]

Assuming that E5 is never negative, another way would be

=SUM(F5:H5)*MAX(E5,1)

Thanks jasonb75, your suggestion worked.

 

[jasonb75]

Both formulas suggestions work (see below) my formula in I5:I7, GWteB's formula in J5:J7

Book12345.xlsm
	E	F	G	H	I	J
5	1	10		5	15	15
6	0		10		10	10
8	2	10		20	60	60
Sheet7

Cell Formulas
Range	Formula
I8,I5:I6	I5	=SUMPRODUCT(F5:H5*MAX(E5,1))
J8,J5:J6	J5	=IF(E5=0, SUM(F5:H5), SUM(F5:H5)*E5)

edit:- actually a variation of my suggestion, I forgot which one I had posted.

 

[Nitsalet]

.... and fwiw, multiplying by 1 gives the same result so can be omitted.

OK, I see that now. Thanks for the help!

 

[GWteB]

you're welcome and thanks for letting us know.