Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel 2007 Home and Studentl: calculation results in blank cell

29 Nov 2011   #1
rundwald

Home Premium 64 bit
 
 
Excel 2007 Home and Studentl: calculation results in blank cell

A strange thing is happening on one of my Excel spreadsheets.

If I put a value in cell A and another in B and use cell C for the result of my calculation, cell C produces a blank. Cell C, however, does show what is input directly to it.

Please! Why is that happening and what is the cure?


My System SpecsSystem Spec
.
29 Nov 2011   #2
seavixen32

Windows 7 Ultimate SP1 64-Bit
 
 

It will help us to help you if you post the exact formula you use to get the result of your calculation.
My System SpecsSystem Spec
29 Nov 2011   #3
rundwald

Home Premium 64 bit
 
 

It was a very simple one. By example

Cell A value 455 Cell B value 0.80 Cell C = value cell A/ value cell B. Result in cell C shoulld be 568.75, but cell C remains blank
My System SpecsSystem Spec
.

29 Nov 2011   #4
seavixen32

Windows 7 Ultimate SP1 64-Bit
 
 

Assuming we're using cells A1, B1 and C1 all you need is this formula in C1:

=A1/B1

where A1 contains the number 455 and B1 contains the number 0.80

In other words, all you are telling C1 to do is divide the contents of A1 by the contents of B1.
My System SpecsSystem Spec
29 Nov 2011   #5
rundwald

Home Premium 64 bit
 
 

Yes, I know that and that is what I am doing. The question is why am I seeing a blank in the result cell.
My System SpecsSystem Spec
29 Nov 2011   #6
strollin

W7 Ult desktop, W10 laptop, W10 laptop, W8.1 tablet
 
 

I don't have that version of Excel but I wonder if you have some sort of rule set (conditional formatting) where it blanks the cell when a particular condition is present? When you select cell C1 do you see the formula there?
My System SpecsSystem Spec
29 Nov 2011   #7
seavixen32

Windows 7 Ultimate SP1 64-Bit
 
 

What do you see in the Formula bar for the calculation?

-excel.jpg

Also, have you checked the formatting for Column C?


My System SpecsSystem Spec
29 Nov 2011   #8
Dwarf

Windows 8.1 Pro RTM x64
 
 

There should be no reason why a simple formula like that shouldn't work. The only thing that I can think of is that one (or both) of the data type(s) is/are incompatible with the function you are trying to use with them, or that the destination location is formulated as being of an incompatible data type for the result of the said function.

Try selecting the whole worksheet and setting its data type to General to see if that resolves your issue.
My System SpecsSystem Spec
29 Nov 2011   #9
strollin

W7 Ult desktop, W10 laptop, W10 laptop, W8.1 tablet
 
 

Hmmm... This one has been tagged as solved but what was the solution? It might help someone else with the same problem later on.
My System SpecsSystem Spec
29 Nov 2011   #10
seavixen32

Windows 7 Ultimate SP1 64-Bit
 
 

Quote   Quote: Originally Posted by strollin View Post
Hmmm... This one has been tagged as solved but what was the solution? It might help someone else with the same problem later on.
Couldn't agree more.
My System SpecsSystem Spec
Reply

 Excel 2007 Home and Studentl: calculation results in blank cell




Thread Tools




Similar help and support threads
Thread Forum
Can I compare 2 Excel spreadsheets cell by cell?
I have an Excel 2010 workbook comprising a simple organization membership list, consisting of names, addresses, etc., for nearly 2,000 members, grouped into 5 chapters' sheets, in a single Excel 2010 file. Every time I sit down to enter updates for any member, or add new members, etc., I always ...
Microsoft Office
Excel cell
Office 2010/Excel I accidentally entered an email address into a cell and now I can't get rid of that format in that cell. No matter what I do, whenever I try to enter text into that cell it is always illuminated in blue and is underlined, just like email addresses are. How can I make this cell...
Microsoft Office
Excel 2010 Multiply cell
I am kinda stuck with this issue, basically what I want to do is multiply any number which is put in row H by 10 and put the value in the next cell in row I, how can I do this? Thanks
Microsoft Office
Excel: How can I insert the value of cell into ActiveX button caption?
Hi, I'm using Office 2007 and I have an Excel file that I have to update often. Therefore I will automate certain tasks using macros accessible by ActiveX Control command buttons. However, I would like for the captions to be relative to information found in certain cells; examples of a caption I...
Microsoft Office
Cannot access the Ribbon functions in Excel 2007 or Word 2007
I have Office 2007 on Windows 7. When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen). If, I switch to another open sheet/doc and then switch back the ribbon is accessible again! I have...
Microsoft Office
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 02:25.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App