•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Looking for a better way to do a multplication formula
Going to attempt to word this where it is understandable.
Right now I am having to manually type in the cell number into my formula for each area I would need it.
For example =A35*2 written in cell A37 and having the *2 number two spaces above.
Do I need to keep writing the cell numbers over and over in each space or is there an option to list *two cells above* multiplied by 2?
Photo of what I am trying to accomplish. The values would obviously be different each use of this function.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#rows.com
#formula generator
#Excel compatibility
#Excel alternatives
#multiplication
#formula
#cell number
#multiply by 2
#manually type
#cells above
#function
#A35
#A37
#list option
#cell reference
#space