SOLUTION: Hello! what is the logic to write in excel if I have a list of 5000 numbers but need to only show all numbers that are divisible by 50? Thanks and happy new year Chris

Algebra ->  Proofs -> SOLUTION: Hello! what is the logic to write in excel if I have a list of 5000 numbers but need to only show all numbers that are divisible by 50? Thanks and happy new year Chris      Log On


   

Question 389409: Hello!
what is the logic to write in excel if I have a list of 5000 numbers but need to only show all numbers that are divisible by 50?
Thanks and happy new year
Chris
Answer by richard1234(7193) About Me  (Show Source):
You can put this solution on YOUR website!
Write 50 in the first row (say, A1), write 100 in A2. Highlight A1-A2, then drag the cursor down to whatever row you'd like.