Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function with Multiple Criteria...
In the following formula, what does the ",1,0" stand for at the end of
the formula? Also, what does the "Amount" at the end stand for as well. =SUM(IF((Place="Down")+(Difference<0),1,0)*Amount Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function with Multiple Criteria...
1 is what is returned if the "IF" Statement returns true, 0 if false.
Amount appears to be a named range. HTH Die_Another_Day wrote: In the following formula, what does the ",1,0" stand for at the end of the formula? Also, what does the "Amount" at the end stand for as well. =SUM(IF((Place="Down")+(Difference<0),1,0)*Amount Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function with Multiple Criteria...
It is used to give the SUM something to add up. The formula is doing a count
in reality, so it sums 1 if the condition is met, 0 if it isn't. The *Amount at the end seems odd though, and it isn't helped by the fact that what you posted is incorrect, there is a bracket missing, but if it should be at the end it makes some sort of sense. But assuming this is so, multiplying by a number means that the 1,0 is superfluous, =SUM(IF((Place="Down")+(difference<0),Amount)) works just as well. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) wrote in message ps.com... In the following formula, what does the ",1,0" stand for at the end of the formula? Also, what does the "Amount" at the end stand for as well. =SUM(IF((Place="Down")+(Difference<0),1,0)*Amount Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Function with multiple criteria | Excel Worksheet Functions | |||
If function multiple Criteria | Excel Discussion (Misc queries) | |||
Multiple results from multiple criteria using IF function | Excel Discussion (Misc queries) | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
Look up function for multiple criteria | Excel Worksheet Functions |