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...
Forum Discussion
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.
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.