•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
Our take
Are you looking for a more efficient way to handle multiplication formulas in your spreadsheet? Instead of manually entering cell references for each calculation, consider leveraging relative referencing. This allows you to create a formula that automatically adjusts based on its position. For example, instead of typing =A35*2 in multiple cells, you can use a formula that references the cell two spaces above dynamically. This approach simplifies your workflow and enhances productivity. Let’s explore how you can implement this innovative solution effectively.
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]
Read on the original site
Open the publisher's page for the full experience
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