no values in uploaded document when using 0 in formula
Hi,
I recently started using Zoho and it works pretty well. I have however a very anoying issue.
I use a lot of formulas and I have problems in my uploaded sheet with cells that get a value zero while in my offline document these cells have a calculated value.
The formula is
=(I5*$I$2)+(J5*$J$2)+(K5*$K$2)+(L5*$L$2)+(M5*$M$2)+(N5*$N$2)+(O5*$O$2)
the I5 J5 etc... values are
2,11 7,18 23,09 82,06 180,00 2233,80 4027,50
the I2 J2 etc.. values are
2280140 489013 125053 20021 0 1973 784
the result in the offline document = 20417453
the result in the uploaded document = 0
I have this problem on all the lines where I have one of the values a Zero (0)
Please assist
Thanks
Kristoff
tbyt