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

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.Com

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) (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.
RELATED QUESTIONS
Could you help me to understand the complex numbers formulas and specially their signs?... (answered by ptaylor)

When this assignment is completed please send it to my graduate assistant (email address... (answered by solver91311)

The following project uses the game of Guess Your Card. This is a game in which each... (answered by chessace)

If I have a 5 yr. old boy who has a BMI of 18 and the BMI is considered a normally... (answered by stanbon)

Hi , I was hoping you could help me with two more question. I have tried to find a... (answered by solver91311,Ganesha)

What is the smallest number that has a remainder of 0 when divided by 16 and 36? I have... (answered by jim_thompson5910)

Hello- I need,(in a 6th grade defintion),help on DIVISIBILTY, and PRIME AND... (answered by rapaljer)

Use the quadratic formula to determine the x-intercepts (if any) of the following... (answered by scott8148)

Hello, I need help to find the sum of the first 500 integers. I know that the answer is... (answered by josgarithmetic)