3885 Views 6 Replies Latest reply: Nov 9, 2010 10:01 PM by Barry
Two thoughts... first, your function leaves one possibility open -- what value should B be set to, if A = 100?
That being said, here's how to write the function:
Let's assume that A is in call A3 and B is cell B3. Then, in cell B3, the function would be:
=if(a3>100, a3*.75, if(a3<100, a3-25))
Note that the "else" part of the nested if statement is blank. Try entering 100 in A3, and see what you get... ;^)
Thanks Larry!! That did it! except for your perceived "100" issue, which I solved by making it less than 101.
I don't see the need for a second IF statement.
the syntax on IF is:
From your statement above, I gather you want A to be multiplied by 0.75 for values of up to and including 100, and to be reduced by 25 for values greater than 100. Written so that those two conditions are mutually exclusive (ie. no gap or overlap), you need only one condition statement.
Since in your particular case the result for A=100 is the same whether it's multiplied by 0.75 or has 25 subtracted from it, you would get the same results by putting 100 on the 'false' side of the condition:
<div class="jive-quote">I had figured out all of the easier functions, but this one threw me for a loop, and I couldn't find this in the Apple Formulas Guide.
iWork Formulas and Functions User Guide, page 158, in discussion of the IF function:
If the Boolean value of if-expression is TRUE, the function returns the if-true
expression; otherwise it returns the if-false expression.
Both if-true and if-false *can contain additional IF functions (nested IF functions).*