How do I create a formula that's extensive?

Microsoft Corporation download - microso...
October 13, 2010 at 09:34:27
Specs: Windows XP
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.

See More: How do I create a formula thats extensive?

Report •


#1
October 13, 2010 at 10:00:03
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))


Report •

#2
October 13, 2010 at 10:03:40
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...".

Product is the result of a multiplication operation, not an addition operation.


Report •

#3
October 13, 2010 at 10:04:12
Thanks, I will try that!

Report •
Related Solutions


Ask Question