I was wondering how I could multiply every previous cell in a column with a specifc number.
For example we have 2 and I want to multiply it with 3 so the cell under 2 would be 6 and I want it to multiply 6 with 3 and then 18 by 3 and so on and so on. But not manually. I want it to be a formula or something because I want to do it for a lot of numbers.
So what I want is for an empty cell to become the multiplication of a number(of my choice, like 3 in the above example) and the cell above it.
Thanks, it woukd mean a lot!