0

So, I want to continuously divide something. I have a number, and I want to divide it into a new number, and then divide that new number, and so on. How do I make a google spreadsheet do this?

  • If you have to divide by the same number all the time simply go with power i.e. 666/3^6. If you also need all steps use this formula =ARRAYFORMULA(42/2^(SEQUENCE(5,1,1,1))) where 42 is initial number, 2 is divisor, 5 is number of times you want to divide. If you need something else - add more details. – Oleg_S Oct 6 at 14:56
  • That's everything I needed @OlegS, thank you very much! If you make your comment an answer, I'll accept it. – Alve Kvåle Oct 6 at 15:01
0

If you have to divide by the same number all the time simply go with power i.e. 666/3^6

If you also need all steps of calculation use this formula

=ARRAYFORMULA(42/2^(SEQUENCE(5,1,1,1))) 

where 42 is initial number, 2 is divisor, 5 is number of times you want to divide.

| improve this answer | |
0

You can cascade the calculations. In A1 enter the initial amount. In B1 enter the divisor. In A2 enter:

=A1/$B$1

Copy this formula downward.

enter image description here

In this method each value is based on the value above it.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.