How do I save the results of a calculation I have made
Everyday I have to do price adjustments for certain items my company sells, it is then printed out on a piece of paper and distributed to the appropriate people. I have been doing this manually, however I believe there should be a way ti use excel to make this quicker. Essentially I have a price in column A, the tax price in column B (this is largely the same number for everything), and then I have a simple =sum (A1:B1) in column C. I also have cell F1 as the adjustment I need to make for the day (for example a -.5 would mean a decrease in price by 50 cents)
Ideally I should be able to have column A as a formula to figure out the price adjustments. This could be something like =price + F1. The issue is that I need the value in column A to save so that I only have to adjust F1 as to what I want for that day.
Is there any way this is possible?
[link] [comments]
Want to read more?
Check out the full article on the original site