Division in a column in excel.

C

ChrisB

How do I divide an entire column by a specific number? Furthermore, is
it possible to round those numbers so I dont get "4.758" for example,
and can it overlook text in the same column on certain cells ?
 
J

Jason Lepack

You mean like this?

Assuming the numbers you want to divide are in Column A, place this
formula in B1 and fill down.

I don't know why you would want to have text in column with a bunch of
numbers in the first place, but this should do the trick. If it
doesn't, post back.

=IF(ISERROR(ROUND(A1/2,0)),"",ROUND(A1/2,0))

Cheers,
Jason Lepack
 
Top