1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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?

submitted by /u/Warhorse173
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article