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 Computer
At a glance
Home Premium 64 bit2.9 gigahertz Intel Core2 Duo 64 kilobyte pri...4096 Megabytes Usable Installed Memory Slot '...ATI Radeon HD 4300/4500 Series
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Dell Inspiron 560MT
OS
Home Premium 64 bit
CPU
2.9 gigahertz Intel Core2 Duo 64 kilobyte primary memory cac
Motherboard
Board: Dell Inc. 0K83V0 A00 Serial Number: ..CN750939CP069B
Memory
4096 Megabytes Usable Installed Memory Slot 'DIMM0' has 102
Graphics Card(s)
ATI Radeon HD 4300/4500 Series
Sound Card
High Definition Audio Device NVIDIA High Definition Audio (
Monitor(s) Displays
DELL ST2210 [Monitor] (21.7"vis, s/n P479R01Q0VCU, January 2
Screen Resolution
1920x1080
Hard Drives
628.58 Gigabytes Usable Hard Drive Capacity
554.78 Gigabytes Hard Drive Free Space
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 Computer
At a glance
W10 Pro desktop, W11 laptop, W11 Pro tablet (...3.7Ghz 8700K i7, i7-11800H, i7-1065G716G desktop, 16G laptop, 4G tabletAMD Radeon RX580, RTX 3060, Intel Iris Plus
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Home Built desktop, Dell G15 5511 Gaming laptop,MS Surface Pro 7 tablet
OS
W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
CPU
3.7Ghz 8700K i7, i7-11800H, i7-1065G7
Motherboard
ASUS TUF Z370-Pro Gaming in desktop
Memory
16G desktop, 16G laptop, 4G tablet
Graphics Card(s)
AMD Radeon RX580, RTX 3060, Intel Iris Plus
Sound Card
High Definition Audio (Built-in to mobo)
Monitor(s) Displays
Samsung U32J59 32" (2x), 15.6", 12"
Screen Resolution
3840x2160, 3840x2160, 1920x1080, 2160x1440
Hard Drives
500G SSD for OS; 2T, 10T & 15T HDDs for Data on Desktop, 1TB SSD laptop, 128G SSD tablet.
PSU
Corsair CX 750M
Case
Antec 100
Cooling
CM 212+
Keyboard
IBM Model M - used continuously since 1986
Mouse
Microsoft Pro IntelliMouse
Internet Speed
400M down 8M up
Antivirus
Windows Defender
Browser
FireFox
Other Info
Built my first computer (8Mhz 8088cpu, 640K RAM, 20MB HDD, 2 360K floppy drives) in 1985 and have been building them for myself, relatives and friends ever since.
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 Computer
At a glance
Windows 8.1 Pro RTM x64Intel Core-i5-3570K 4-core @ 3.4GHz (Ivy Brid...4 x 4GB DDR3-1600 Corsair Vengeance CMZ8GX3M2...MSI GeForce GTX770 Gaming OC 2GB
4 x 4GB DDR3-1600 Corsair Vengeance CMZ8GX3M2A1600C9B (16GB)
Graphics Card(s)
MSI GeForce GTX770 Gaming OC 2GB
Sound Card
Realtek High Definition on board solution (ALC 898)
Monitor(s) Displays
ViewSonic VA1912w Widescreen (VGA)
Screen Resolution
1440x900
Hard Drives
OCZ Agility 3 SSD 120GB SATA III x2 (RAID 0)
Samsung HD501LJ 500GB SATA II x2
Hitachi HDS721010CLA332 1TB SATA II
Iomega 1.5TB Ext USB 2.0
WD 2.0TB Ext USB 3.0
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 Computer
At a glance
W10 Pro desktop, W11 laptop, W11 Pro tablet (...3.7Ghz 8700K i7, i7-11800H, i7-1065G716G desktop, 16G laptop, 4G tabletAMD Radeon RX580, RTX 3060, Intel Iris Plus
Computer type
PC/Desktop
Computer Manufacturer/Model Number
Home Built desktop, Dell G15 5511 Gaming laptop,MS Surface Pro 7 tablet
OS
W10 Pro desktop, W11 laptop, W11 Pro tablet (all 64-bit)
CPU
3.7Ghz 8700K i7, i7-11800H, i7-1065G7
Motherboard
ASUS TUF Z370-Pro Gaming in desktop
Memory
16G desktop, 16G laptop, 4G tablet
Graphics Card(s)
AMD Radeon RX580, RTX 3060, Intel Iris Plus
Sound Card
High Definition Audio (Built-in to mobo)
Monitor(s) Displays
Samsung U32J59 32" (2x), 15.6", 12"
Screen Resolution
3840x2160, 3840x2160, 1920x1080, 2160x1440
Hard Drives
500G SSD for OS; 2T, 10T & 15T HDDs for Data on Desktop, 1TB SSD laptop, 128G SSD tablet.
PSU
Corsair CX 750M
Case
Antec 100
Cooling
CM 212+
Keyboard
IBM Model M - used continuously since 1986
Mouse
Microsoft Pro IntelliMouse
Internet Speed
400M down 8M up
Antivirus
Windows Defender
Browser
FireFox
Other Info
Built my first computer (8Mhz 8088cpu, 640K RAM, 20MB HDD, 2 360K floppy drives) in 1985 and have been building them for myself, relatives and friends ever since.
4 x 4GB DDR3-1600 Corsair Vengeance CMZ8GX3M2A1600C9B (16GB)
Graphics Card(s)
MSI GeForce GTX770 Gaming OC 2GB
Sound Card
Realtek High Definition on board solution (ALC 898)
Monitor(s) Displays
ViewSonic VA1912w Widescreen (VGA)
Screen Resolution
1440x900
Hard Drives
OCZ Agility 3 SSD 120GB SATA III x2 (RAID 0)
Samsung HD501LJ 500GB SATA II x2
Hitachi HDS721010CLA332 1TB SATA II
Iomega 1.5TB Ext USB 2.0
WD 2.0TB Ext USB 3.0
