Excel math problem

[BrianThompson1]

I am trying to write an IF function for an invoice. I need to have the subtotal*tax rate - payment, if payment is made = total. Anyone know a formula that would make that work? Any help would be appreciated.

[#2 · Accepted solution]

=IF(A2="Paid",(Subtotal*tax rate) - payment,"Anything")
You just need to replace what is written in this formula for your refereces where their respective values are.

[#3]

Ok, so I have =IF(D17="Payments",(Subtotal*tax rate) - payment,"Anything") Does that look right?

[#4]

Yes.
Remember you need to replace the names for proper values or reference
Subtotal cell
Tax Rate cell
Payment Cell

[#5]

Thank you, I am very new to excel and I am trying to get this invoice to work. I had it working just fine. Until I added the payment part. Somehow I broke the original and its no longer calculating for the subtotal.

[#6]

No problem. If you face more difficulty, please share it here so we can try to assist you.

[#7]

Like I said, just trying to fix the subtotal not calculating right.

[#8]

Is it possible you share some screeshot of your invoice template or even better the template itself?
This way will be easier to reply based on you case

[#9]

I got it fixed, thanks so much