antsaresocrazy
New Member
- Joined
- Apr 7, 2013
- Messages
- 2
I would have searched for this one, if even could begin to know how to approach it. Any help or thread reference (if its been talked about before) would be really appreciated!
I'm writing a budget worksheet, and I would like people to be able to enter EITHER tax percentage or deducted amount and have it calculate the other.
So in this screen shot, the person can only enter the blue fields...
But then i thought, what if they don't know the percentage and only have the totals to go on? Is there a way that they can enter the total, and have it calculate the tax and/or enter the tax and have it calculate the total?
So essentially it could go both ways...
My immediate inclination is that I'll have to make another sheet that has these two separate equations in them.
Any thoughts? Thanks so much for the time! I love this forum!
John
I'm writing a budget worksheet, and I would like people to be able to enter EITHER tax percentage or deducted amount and have it calculate the other.
So in this screen shot, the person can only enter the blue fields...
But then i thought, what if they don't know the percentage and only have the totals to go on? Is there a way that they can enter the total, and have it calculate the tax and/or enter the tax and have it calculate the total?
So essentially it could go both ways...
My immediate inclination is that I'll have to make another sheet that has these two separate equations in them.
Any thoughts? Thanks so much for the time! I love this forum!
John