OpenOffice Calculator Coding Problem
Posted: 2007-09-29 11:45pm
I need some help with the program found here (zip file of a .ods file). E18 should have a value of 10 - it's a long formula, but it's supposed to essentially sum 5 times the value of B18, L26, and M26. It's supposed to keep doing that with B18 and going down the L and M columns. However, while testing showed that it does recognize that L26 is 1 and M26 is 2, L26+M26 is 1, and L26*M26 is 2, so apparently it's not reading M26 as a number for mathematical functions, and I can't figure out why. Can anyone provide a solution for me?
Thanks.
Thanks.