jesstercpa
New Member
- Joined
- Mar 1, 2002
- Messages
- 4
Good morning.
I need a formula figured out and I just keep running into a wall with this one. Your help is greatly appreciated.
I have to calculate interest on a tax lien and subsequent tax payments. The first $1500 gets charged 8%, the rest get 18%. I have in column H the total lien. Then in column U I have the subsequent payments. What keeps baffling me is how to do this if the lien is less than $1500, then the subsequent payments bring the total over $1500. I hope I have not confused you all.
Thanks again for your help!
I need a formula figured out and I just keep running into a wall with this one. Your help is greatly appreciated.
I have to calculate interest on a tax lien and subsequent tax payments. The first $1500 gets charged 8%, the rest get 18%. I have in column H the total lien. Then in column U I have the subsequent payments. What keeps baffling me is how to do this if the lien is less than $1500, then the subsequent payments bring the total over $1500. I hope I have not confused you all.
Thanks again for your help!