4 replies
by cmikesh Accepted solution
by thumbsup2 Accepted solution
it's a formula problem, not a calculation problem. If you're getting zeros in CHANGED cells, your formulas are doing exactly what you told them to do AND they can find the source data AND they're calculating. If they weren't, you would get an error.
If these formulas used the conditional sum wizard that sets the { } curley brackets around the formula, you need to hold CTRL+SHIFT while pressing ENTER in that cell after you have changed it.
by evan.frantzeskos Accepted solution
by gasummer Accepted solution
When sharing a spreadsheet that required BIN2DEC & DEC2BIN functions, other users couldn't get the values to calculate because they did not have the Analysis Toolpak addins.
When they sent the spreadsheet back to me, the vaules would not calculate without copying the formulas anew.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending