Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2023, 11:43 AM
321Fred 321Fred is offline Disappearing Formula Result ! Windows 10 Disappearing Formula Result ! Office 2021
Novice
Disappearing Formula Result !
 
Join Date: Nov 2023
Posts: 3
321Fred is on a distinguished road
Default Disappearing Formula Result !


I have a spreadsheet with numerous formulas all have been working properly till two days ago. One cell with a formula just stopped displaying the results out a the blue! I tried re-entering the formula, checked to make sure the text color didn't match the background color, rechecked the formatting as currency, verified no conditional format, verified I hadn't hidden the cell some how but found nothing different. The c ell will show text when typed just no formula in that cell or any other cells on the page! The remaining cells that do have formula's are still showing results, I just can't type any formulas in any other cells that didn't already have data.

Anyone have a idea what has happened here?
Reply With Quote
  #2  
Old 11-29-2023, 03:52 PM
Alansidman's Avatar
Alansidman Alansidman is offline Disappearing Formula Result ! Windows 11 Disappearing Formula Result ! Office 2021
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 78
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

See if this helps

Display or hide formulas - Microsoft Support.
__________________
Alan עַם יִשְׂרָאֵל חַי
Reply With Quote
  #3  
Old 11-30-2023, 05:43 AM
321Fred 321Fred is offline Disappearing Formula Result ! Windows 10 Disappearing Formula Result ! Office 2021
Novice
Disappearing Formula Result !
 
Join Date: Nov 2023
Posts: 3
321Fred is on a distinguished road
Default Easy Come Easy Go ?

I had already checked to make sure nothing had changed regarding showing or not showing formula's.

However by checking "show formulas" you get the formulas showing in cells rather than the result your looking for.

Anyway for what ever reason just as that particular cell resulting formula disappeared later the same day after looking for help as to what was going on (hours later) I went back to my computer and low an behold that cell once again was showing the result expected out a the blue.

Go figure ?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disappearing Formula Result ! How to change the formula to get this result .... LearnerExcel Excel Programming 2 02-11-2018 08:26 PM
IF Formula not returns result - Help Haha88 Excel 6 02-11-2018 02:07 PM
Disappearing Formula Result ! formula, 2 criteria, one result cjdstephenson Excel 4 06-02-2015 09:17 PM
Disappearing Formula Result ! Show result of formula as a value in another cell Steve_D Excel 4 10-12-2014 07:38 PM
IF formula returns wrong result mashley Excel 3 09-07-2012 07:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:25 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft