Microsoft Excel help. can't think of what to name this problem
2 replies, posted
Hello guys,
I cannot come up with what words to use to search for this problem, so LMGTFY isn't really a solution here.
What I am trying to do, is to get two cells linked to eachother in Excel.
At the moment I have a sheet, in which I input buy price, sales price and then it calculates VAT and profit.
It works perfectly after I input the needed variables. But what I now want to do is be able to input the profit, and then have the require sales price update automatically.
Is this possible on excel? Or do I have to create a new scheme and 'program' it manually?
Do you want to calculate tax per item, or do you want to calculate tax on a total amount of several items?
You could do something like this per item to calculate tax:
=CEILING(A1*1.0825,0.01)
This would calculate the value of cell A1 with a tax rate of 8.25% and round up to the nearest second integer to the right of the decimal. So if the cost of the item was $49.99, the total would be $54.114175, or $54.12 rounded with this formula.
Calculating profit is easy, you just subtract the cost you paid for the item from the total sale price you sold it for, minus tax of course.
There is a feature called goal seek which I think would do what you want.
Gigabite's shit might be easier though, I'm no excel pro.
Sorry, you need to Log In to post a reply to this thread.