Multiply only when values in a row are positive

**Eric Stecker** · 07-24-2016, 11:25 PM

I want to multiply the value in 2 cells in a row but only if both cells contain a positive number. If either cell or both cells contains a negative number then I want the output cell to display as 0. Can this be done?

Thanks,
Eric

**FlameRetired** · 07-24-2016, 11:35 PM

Do you mean something like this?

Row\Col	A	B	C	D
1	Num1	Num2	If both > 0
2	4	1	4	*=IF(AND(A2>0,B2>0),A2B2,0)**
3	1	4	4
4	-2	-3	0
5	3	-3	0
6	4	5	20
7	5	0	0
8	4	3	12
9	-3	5	0
10	0	-1	0

**sktneer** · 07-24-2016, 11:39 PM

Or you may try it like this......

Assuming the cells in the interest are A2 and B2, then try...

=IF(MIN(A2:B2)<0,0,A2*B2)

OR

=(MIN(A2:B2)>0)*A2*B2

**Eric Stecker** · 07-25-2016, 12:58 AM

Thank you. I figured out a work around but this will be useful in the future.

Regards,
Eric

**sktneer** · 07-25-2016, 01:01 AM

If your issue is resolved, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

**Eric Stecker** · 07-25-2016, 01:42 AM

Done. Thanks again. I will be back.

Multiply only when values in a row are positive

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View