Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Modulus by column (https://www.askmehelpdesk.com/showthread.php?t=86818)

  • Apr 26, 2007, 11:37 PM
    allison79
    modulus by column
    hi. I am trying to apply the modulus function to an entire column of data. I am obviously doing something wrong though, as I wind up getting the modulus value for the first cell in the column only. How can I apply the modulus function to an entire column of data? Thanks.
  • Apr 26, 2007, 11:40 PM
    Capuchin
    Well, you need to create a formula for the first cell, then drag it down the column?

    Do you have $s in the formula by accident?
  • Apr 27, 2007, 12:35 AM
    allison79
    hi, thanks for the reply. No I don't have $s in my formula, I was doing it like this for example: =mod(A1:A186,2000). I have no clue...
  • Apr 27, 2007, 12:38 AM
    Capuchin
    You're doing the mod for the whole column in one cell? This isn't how you need to do it.

    in B1 you need =mod(A1,2000)
    then in B2 you need =mod(A2, 2000)

    you can carry this all the way down by selecting your first number, clicking and holding the little square in the bottom right, and draggin all the way down to B186.

    This should give you what I think you are looking to do.
  • Apr 27, 2007, 01:14 AM
    allison79
    You are a genius, thank you!
  • Apr 27, 2007, 01:17 AM
    Capuchin
    I aim to please ;)

  • All times are GMT -7. The time now is 11:21 AM.