Microsoft Corporation download - microso...

I need to create a formula and don't know which one to use. I have a group of numbers to add up. if the resulting product of those numbers is less than another group of numbers, I want the answer to be Zero, even if it would normally be a negative number.

This formula will compare the SUM of A1:A5 to the SUM of B1:B5 and return 0 if it's less than the SUM of B1:B5, otherwise it will return the SUM of A1:A5.

=IF(SUM(A1:A5)<SUM(B1:B5),0,SUM(A1:A5))

P.S. You said that you have " a group of numbers to add up" but then you said "if the resulting product of those numbers is...".

Productis the result of amultiplicationoperation, not anadditionoperation.

Thanks, I will try that!

Ask Your Question

Weekly Poll