Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel: value not appearing in cell
Name: Annik Date: December 28, 2005 at 14:36:08 Pacific OS: Windows XP CPU/Ram: 256
Comment:
I have a formula in a cell (which was copied from another file) and instead of the calculated value appearing in the cell, it's the formula. It works in the original file but I can't get it to calculate in the new one. Can anyone help?
Name: Jennifer SUMN Date: December 28, 2005 at 15:53:56 Pacific
Reply:
What is the syntax of the formula, and how is the cell formatted?
Soylent Green is PEOPLE!!!
0
Response Number 2
Name: Annik Date: December 29, 2005 at 06:14:27 Pacific
Reply:
In the cell: {=SUM(IF($K$13:$K$854=J3,IF($F$13:$F$854=1,1,0)))}
The cell is formatted as General.
Thanks for your help.
0
Response Number 3
Name: cach Date: December 30, 2005 at 13:59:48 Pacific
Reply:
If you need a quick fix, does this help?
Edit your copied formula via F2 to delete the braces {} at each end then position cursor at the end of the formula and press ctrl, shift and enter together.
Summary: Hi chaps I'm not very good at Excel for which I apologise! I am trying to populate a cell with the results of a sum in another cell. What I have is a kind of grid, if the value in cell A1 is 0 the...
Summary: Excel will not change the format of selected cells. I cut and pasted a table that I sorted on line. The problem after the import is that Excel will not change the format of selected cells. I am tryi...
Summary: Hi. I'm wondering if there are any Excel experts out there who can help me to redistribute a whole load of cells without having to do so one by one (and thus also probably making mistakes)? I'm workin...
0 
