when to use double (( in a formual

[coalville]

what i want to know is when to use double (( and )) in formuals an example formual which i have used is below

=IF(($A$1-B2)*20%<=0,0,IF(($A$1-B2)*20%>7200,7200,($A$1-B2)*20%))

[darkyam]

There is no double ((, only two sets of parentheses. Each parenthetical statement is offset from and calculated before the rest of the formula. Having (( means that you are starting one parenthetical statement and immediately starting another within it. Since each parenthetical statment has to have both ( and ), if you have one such statement in another, it often happens that they will either begin or end at the same time, thus requiring (( or )). HTH.

[ChemistB]

Excel does follow the traditional hierarchy of math which can be remembered with the mnemonic "Please Excuse My Dear Aunt Sally" Using the first letter of each word Parentheses, Exponents, Multiplication, Division, Addition, Subtraction (with M and D being equal and A and S being equal). So with your equation

Please Login or Register  to view this content.

you want cell A1 subtracted from B2 BEFORE it's multiplied by 20% so you need the parentheses around that to bump it up on the hierarchy. Make sense?

ChemistB