Skip to main content
Question

Need help with an If, then formula

I am attempting to calculate the sales tax based on some different conditions.

If([Tax Exempt]=false, [Sub Total]*0.0725, ([Rebate Used from Last Month?]="No" & [Tax Exempt]=false), [Grand Total]*0.0725)

First off, when this is used, it shows my Sales Tax field as blank. Whenever I go into edit it, it will show no yellow errors, but when I save it, I get a popup stating that a closed parenthesis is missing. Any help would be greatly appreciated.
    This topic has been closed for replies.

    Forum|alt.badge.img+14
    One issue is that you are using the same [Tax Exempt]=false in both parts of your IF statement; so for a record where that is true; your formula is never getting past the 1st statement.  There are also other issues with your formula.

    Try a Case() statement alternative:

    Case(true,
    [Rebate Used from Last Month?]="No" and [Tax Exempt]=false,[Grand Total]*0.0725,
    [Tax Exempt]=false, [Sub Total]*0.0725
    )

    Note that when Tax Exempt is true; you do not have any calculation being made.
    Laura Thacker | laura@intelligentdbs.com | (626) 771 0454
    Thank you so much! It worked! I tried the Case function, but I didn't have the 'true' part there at the beginning.
    Terms & ConditionsAccessibility statement