Search code examples
google-sheetsgoogle-sheets-formula

Sheets formula to display all quotients and remainders of X divided by Y


Need a formula that outputs the result below shown in the screenshot below:

enter image description here

I tried a combination of QUOTIENT() and MOD() functions.


Solution

  • You may try something in the style of:

    ={sequence(QUOTIENT(A2,C2),1,C2,0);mod(A2,C2)}
    

    enter image description here