Forum Discussion
Solved
Excel math problem
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 appr...
- =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.
Ok, so I have =IF(D17="Payments",(Subtotal*tax rate) - payment,"Anything") Does that look right?
Yes.
Remember you need to replace the names for proper values or reference
Subtotal cell
Tax Rate cell
Payment Cell
Remember you need to replace the names for proper values or reference
Subtotal cell
Tax Rate cell
Payment Cell
- 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.
- No problem. If you face more difficulty, please share it here so we can try to assist you.
- Like I said, just trying to fix the subtotal not calculating right.