1 min readfrom 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.

https://preview.redd.it/fnmp1dy6dj0h1.png?width=414&format=png&auto=webp&s=fdd86045c131652b9f2f79ec52bfcff8fdf7d690

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

Want to read more?

Check out the full article on the original site

View original article