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

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#AI formula generation techniques
#formula generator
#Excel
#price adjustments
#formula
#price
#column A
#column B
#column C
#tax price
#=sum(A1:B1)
#F1
#daily adjustment
#efficient pricing