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 406 posts UK, Hampshire 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 Specs
 .
 29 Nov 2011 #2 seavixen32 Windows 7 Ultimate SP1 64-Bit 329 posts Peterborough, England It will help us to help you if you post the exact formula you use to get the result of your calculation. My System Specs
 29 Nov 2011 #3 rundwald Home Premium 64 bit 406 posts UK, Hampshire 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 Specs
 .
 29 Nov 2011 #4 seavixen32 Windows 7 Ultimate SP1 64-Bit 329 posts Peterborough, England 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 Specs
 29 Nov 2011 #5 rundwald Home Premium 64 bit 406 posts UK, Hampshire 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 Specs
 29 Nov 2011 #6 strollin W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit) 2,386 posts N. Calif 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 Specs
 29 Nov 2011 #7 seavixen32 Windows 7 Ultimate SP1 64-Bit 329 posts Peterborough, England What do you see in the Formula bar for the calculation? Also, have you checked the formatting for Column C? My System Specs
 29 Nov 2011 #8 Dwarf Windows 8.1 Pro RTM x64 10,375 posts Doncaster, UK 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 Specs
 29 Nov 2011 #9 strollin W10 Pro desktop, W10 laptop, W10 laptop, W10 Pro tablet (all 64-bit) 2,386 posts N. Calif 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 Specs
 29 Nov 2011 #10 seavixen32 Windows 7 Ultimate SP1 64-Bit 329 posts Peterborough, England Quote: Originally Posted by strollin 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 Specs