OpenOffice Calculator Coding Problem

GEC: Discuss gaming, computers and electronics and venture into the bizarre world of STGODs.

Moderator: Thanas

Post Reply
User avatar
The Dark
Emperor's Hand
Posts: 7378
Joined: 2002-10-31 10:28pm
Location: Promoting ornithological awareness

OpenOffice Calculator Coding Problem

Post by The Dark »

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.
Stanley Hauerwas wrote:[W]hy is it that no one is angry at the inequality of income in this country? I mean, the inequality of income is unbelievable. Unbelievable. Why isn’t that ever an issue of politics? Because you don’t live in a democracy. You live in a plutocracy. Money rules.
BattleTech for SilCore
Post Reply