Fullastarbucks wrote:

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:

IF(if-condition,if-true,if-false)

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.

=IF(A<=100,A*0.75,A-25)

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:

=IF(A<100,A*0.75,A-25)

<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:

*Usage Notes*

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).*

Regards,

Barry