Solved

# EXCEL calculation matter

Posted on 2014-03-20

I have a long list of numbers, thousands of rows, where I need to divide the number in the row by 57. Problem is, some of those rows are empty and I need for them to stay empty. So it looks something like this: (these are us dollars by the way)

ROW AC

1 3.65

2 3.44

3 7.34

4

5 8.01

6

7 9.11

8 10.19

So i need to divide this entire col by a percentage - .57% so that the value increases to the new number. If I simply do the first one (=sum:AC1/.57) and drag it down the length of the col to copy the math, it works but puts 0.00 in the empty fields, which I do not want.

Is there another means by which I can accomplish this?