Office Software Thread, Excel fomula not evaluating correctly in Technical; I've got a spreadsheet here with a simple set of calculations. Basically each column is summed, then that row is ...
25th September 2012, 11:13 AM #1
Excel fomula not evaluating correctly
I've got a spreadsheet here with a simple set of calculations. Basically each column is summed, then that row is summed at the end.
The columns are summing correctly, but the total at the end just returns 0 all the time.
We've checked that the cells are formatted as numbers/general, we've checked calculation is on auto. If I go into edit the formula and click the 'Calculate Now' button, it calculates correctly, and overwrites the formula with the result.
What on earth is going on?
25th September 2012, 11:24 AM #2
Any chance of uploading file? (To show/test issue I mean). Whether it's real data or fake, just nice to be able to see it
By martyn in forum Scripts
Last Post: 20th February 2008, 05:29 PM
By kearton in forum EduGeek.net Site Problems
Last Post: 9th January 2008, 10:20 AM
Last Post: 19th October 2007, 03:48 PM
Last Post: 1st May 2007, 10:17 AM
By Dos_Box in forum Windows
Last Post: 18th December 2006, 11:07 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)