Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
This is a phenomenonally simple task:
All I want is the formula "=SUM(B38:F38)" result to display on my spreadsheet. Excel shows $0.00 in the cell. The formula result, however, is '$9288.72.' I am so frustrated!!! Thanks for any help with this prob. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Sounds like your numbers are stored as text, format them to a number format.
-- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "Kai" wrote: This is a phenomenonally simple task: All I want is the formula "=SUM(B38:F38)" result to display on my spreadsheet. Excel shows $0.00 in the cell. The formula result, however, is '$9288.72.' I am so frustrated!!! Thanks for any help with this prob. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Likely that calc mode was inadvertently set to Manual here. Press F9, does it
compute properly? To check/change calc mode, click Tools Options Calculation tab. Ensure "Automatic" is checked OK. Along similar vein, another non-computing phenomena to watch out for is the possibility is the cell with the formula might have been pre-formatted as text, unknown to you of course, when you dropped the formula in. In such an instance, just re-format the cell as either general or number (via Format Cells), then re-enter the formula by clicking inside the formula bar and pressing ENTER. Note that re-formatting alone does not trigger calculation, you need to re-enter the formula. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: This is a phenomenonally simple task: All I want is the formula "=SUM(B38:F38)" result to display on my spreadsheet. Excel shows $0.00 in the cell. The formula result, however, is '$9288.72.' I am so frustrated!!! Thanks for any help with this prob. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
"John Bundy" wrote:
Sounds like your numbers are stored as text, format them to a number format. If its the case of text numbers, think re-formatting in itself doesn't change the underlying values. We need to copy an empty cell, then select the source range, eg: B38:F38, right-click paste special add ok. This should convert all text numbers within the source range to real numbers, and the SUM will work. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Hi Max & John,
I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego "Max" wrote: Likely that calc mode was inadvertently set to Manual here. Press F9, does it compute properly? To check/change calc mode, click Tools Options Calculation tab. Ensure "Automatic" is checked OK. Along similar vein, another non-computing phenomena to watch out for is the possibility is the cell with the formula might have been pre-formatted as text, unknown to you of course, when you dropped the formula in. In such an instance, just re-format the cell as either general or number (via Format Cells), then re-enter the formula by clicking inside the formula bar and pressing ENTER. Note that re-formatting alone does not trigger calculation, you need to re-enter the formula. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: This is a phenomenonally simple task: All I want is the formula "=SUM(B38:F38)" result to display on my spreadsheet. Excel shows $0.00 in the cell. The formula result, however, is '$9288.72.' I am so frustrated!!! Thanks for any help with this prob. |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Quite a mystery then <g, given that the usual checks didn't resolve it ..
Perhaps you could use either of the 2 free filehosts listed below to upload your sample book and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: Hi Max & John, I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Here's my standard list
-- Kind regards, Niek Otten Microsoft MVP - Excel ================================================== =============== Your Numbers don't behave (like numbers) Niek Otten, May 11, 2006 Your numbers sort incorrectly, are not included in SUMs, cause #VALUE! results in formulas, cannot be found in LOOKUPs, etc. In short: Your Numbers look like Numbers, but they really are Text. Sure! You formatted them as numbers, but alas, formatting afterwards doesn't help. Believe me, they are Text! Here's a checklist which will help you solve most known cases. Make a copy of your workbook before trying! Always use Excel's ISNUMBER() function to check your cells; maybe you solved your problem in the first step! · Format an empty cell as Number. Enter the number 1 in it. EditCopy. Select your "numbers". EditPaste Special, check Multiply. Hopefully your cells are "real" Numbers now · If that doesn't help, there may be spaces in your "numbers". You can use the LEN() function to compare the number of characters that Excel sees in the cell with the number of characters you see. If you suspect spaces, use Excel's TRIM() function to remove them · If that doesn't help, there may be nonprintable characters in your "numbers". You can use Excel's CLEAN() function to remove most of them · If that doesn't help, there may be non-breaking spaces in your "numbers" (mostly acquired from Web Pages). Use David McRitchie's TRIMALL() function to remove them. It can be downloaded he http://www.mvps.org/dmcritchie/excel/join.htm#trimall ================================================== =============== "Kai" wrote in message ... | Hi Max & John, | | I'd done all you suggested and checked again. Still, I get $0.00 in the | cell and the formula result remains in the formula box. :( | | I have the cell formatted to 'currency.' All my other cells and calcs work | fine. | | Kai | San Diego | | "Max" wrote: | | Likely that calc mode was inadvertently set to Manual here. Press F9, does it | compute properly? To check/change calc mode, click Tools Options | Calculation tab. Ensure "Automatic" is checked OK. | | Along similar vein, another non-computing phenomena to watch out for is the | possibility is the cell with the formula might have been pre-formatted as | text, unknown to you of course, when you dropped the formula in. In such an | instance, just re-format the cell as either general or number (via Format | Cells), then re-enter the formula by clicking inside the formula bar and | pressing ENTER. Note that re-formatting alone does not trigger calculation, | you need to re-enter the formula. | -- | Max | Singapore | http://savefile.com/projects/236895 | xdemechanik | --- | "Kai" wrote: | This is a phenomenonally simple task: | | All I want is the formula "=SUM(B38:F38)" result to display on my | spreadsheet. Excel shows $0.00 in the cell. The formula result, however, is | '$9288.72.' I am so frustrated!!! | | Thanks for any help with this prob. |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc=
The cells in question are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k "Max" wrote: Quite a mystery then <g, given that the usual checks didn't resolve it .. Perhaps you could use either of the 2 free filehosts listed below to upload your sample book and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: Hi Max & John, I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Kai wrote:
Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc= The cells in question are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k "Max" wrote: Quite a mystery then <g, given that the usual checks didn't resolve it .. Perhaps you could use either of the 2 free filehosts listed below to upload your sample book and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: Hi Max & John, I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego Try this in c41 instead of SUM =(B38+F38) |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
gls858 wrote:
Kai wrote: Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc= The cells in question are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k "Max" wrote: Quite a mystery then <g, given that the usual checks didn't resolve it .. Perhaps you could use either of the 2 free filehosts listed below to upload your sample book and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: Hi Max & John, I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego Try this in c41 instead of SUM =(B38+F38) Please ignore..I wasn't looking at it close enough. |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
D38 contains a circular reference, change formula to:
=SUM(D5:D37) George Gee "Kai" wrote in message ... Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc= The cells in question are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k "Max" wrote: Quite a mystery then <g, given that the usual checks didn't resolve it .. Perhaps you could use either of the 2 free filehosts listed below to upload your sample book and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: Hi Max & John, I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego |
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
The hyperlink is not complete, it needs the = sign on the end!
George Gee "Kai" wrote in message ... Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc= The cells in question are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k "Max" wrote: Quite a mystery then <g, given that the usual checks didn't resolve it .. Perhaps you could use either of the 2 free filehosts listed below to upload your sample book and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: Hi Max & John, I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego |
#13
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
It looks like the circular reference error in D38 (one of the precedent
cells) is causing the problem here, as observed by George. If you check the Iterations box (in Tools Options Calculation tab), it'll work as-is (tested here). It's best of course to correct the circular error in D38's formula as George has pointed out. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote in message ... Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc= The cells in are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k |
#14
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Many, many thanks! Sorry about the = sign in the hyperlink.
S "George Gee" wrote: D38 contains a circular reference, change formula to: =SUM(D5:D37) George Gee "Kai" wrote in message ... Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc= The cells in question are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k "Max" wrote: Quite a mystery then <g, given that the usual checks didn't resolve it .. Perhaps you could use either of the 2 free filehosts listed below to upload your sample book and then post the link to it in response here (the link is generated when you upload, just copy and paste it here) http://www.flypicture.com/ http://cjoint.com/index.php For cjoint.com (it's in French), just click the "Browse" button, navigate to folder select the file Open, then click the button centred in the page below (labelled "Creer le lien Cjoint") and it'll generate the link. Then copy & paste the generated link as part and parcel of your response here. Kindly note that no attachments should be posted *directly* to the newsgroup. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote: Hi Max & John, I'd done all you suggested and checked again. Still, I get $0.00 in the cell and the formula result remains in the formula box. :( I have the cell formatted to 'currency.' All my other cells and calcs work fine. Kai San Diego |
#15
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
Thanks for all you time Max. I'm relieved. Amazing, phenomenally simple
problem. Annoyed I didn't figure it out on my own. S "Max" wrote: It looks like the circular reference error in D38 (one of the precedent cells) is causing the problem here, as observed by George. If you check the Iterations box (in Tools Options Calculation tab), it'll work as-is (tested here). It's best of course to correct the circular error in D38's formula as George has pointed out. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote in message ... Here's the link to my WS: http://www.flypicture.com/download/NzM5Mzc= The cells in are C41 and D44. It actually seems like that entire quadrant is involved. As previously noted, when I click the 'fx' icon and get the 'function arguments' box, the result is there. It(the result) just won't post in my designated cell. You may note that another cell in the 38 row works. Thanks for your time and thoughts. k |
#16
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I can't get the formula result to display on my spreadsheet.
No prob. Glad it was nailed down here <g.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Kai" wrote in message ... Thanks for all you time Max. I'm relieved. Amazing, phenomenally simple problem. Annoyed I didn't figure it out on my own. S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
Formula: =PROPER(text), won't display result. | Excel Discussion (Misc queries) | |||
Is it possible? | Excel Worksheet Functions | |||
Display result of formula in header? | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions |