PDA

View Full Version : Solved: division with zero



dani9
01-11-2012, 04:27 AM
HI,

i need help with something... I need to divide all zeros in column with 1000000000, so that i get something like 0,0000001.

Cells(2, m).FormulaR1C1 = "=IF(RC[-28]=0,RC[-28]/1000000,RC[-28])"

this is what i have, but the zeros remain like 0,00, and if i increase the number of decimal places, it is still zero.

Does excel vba automaticall round numbers and how do I avoid that, because i need the 0,0000001 number.

Thanks in advance!

mdmackillop
01-11-2012, 06:26 AM
Dividing zero by anything will always be zero. Why would you expect anything else?