Hi all. I am having a probelm. I have created a worksheet to figure out (in this case) how many sets of Buckyballs i need in order to get both a square number and a cube number. There are 216 balls per set. My worksheet so far has:
Sets Number of balls Square Cube
(Number of sets) (Sets*216) (Number of balls ^0.5) (Number of balls ^(1/3))
The problem is that I am looking for the number of sets required to produce an integer in both Square and Cube columns. I have figured out that I can circle all values that are not integers. I am looking for a way to delete all rows with a decimal value or at least all cells with a decimal value and I can delete the rows from there.
Thank you in advance.
PS. I know that the first answer is 216, but I am looking for the ones after that. So there are 100,000 lines so far. Meaning I want to have the process as automated as possable. Thank you again.
Bookmarks