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 appreciated.
- =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.
8 Replies
- =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
