If-false *can contain additional IF functions (nested IF functions). no gap or overlap), you need only one condition statement. Written so that those two conditions are mutually exclusive (ie. If-expression is TRUE, the function returns the 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. IWork Formulas and Functions User Guide, page 158, in discussion of the IF function: If you would rather merge your documents manually, open each converted XLS document and choose one which will be your master document (or open a new Excel document). This will now be saved to use again when you convert more PDF bank statements. =IF(AI 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. Your bank statements will now all be in one master Excel document on multiple sheets.
I don't see the need for a second IF statement.įrom 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. Thanks Larry!! That did it! except for your perceived '100' issue, which I solved by making it less than 101.
