I am stumped... I am sure there is an easy way to do this but I just can't get there from here today. I hate Mondays...
I have a column with 5 numbers in it. 12, 22.5, 34,47.2, 51.6. Now I need to put in the next column when each time the number in the first column can be divided by 11.5 and put in the cell in second column 11.5 * the number of times it can be divided into the first column number. something like this:
12.0 11.50
22.5
34.0 23.00
47.2 46.00
51.6
Should I use an "if" with a "mod" in it?
Thanks
Tim
Bookmarks