Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 07-04-2014, 11:06 AM
BobBridges's Avatar
BobBridges BobBridges is offline Cell with unresolved formula in has value > 0 Windows 7 64bit Cell with unresolved formula in has value > 0 Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

I just checked to be sure, and, as you might expect, when I have nothing in X99, then X99>0 evaluates as false. So my next theory is that there's something in there already. I just discovered (thanks to your question) that a space is actually considered to be >0. So I'm thinking H5 has a space in it, or more than one.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell with unresolved formula in has value > 0 Formula in cell b1 using cell a1 if a1 is over certain number pumkinbug87 Excel 5 12-03-2013 12:34 PM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
Cell with unresolved formula in has value > 0 Keep cell in formula constant jprt68 Excel 1 06-26-2012 08:31 AM
Cell with unresolved formula in has value > 0 need to check whether cell contains formula etodem Excel 2 10-23-2010 07:33 PM
Cell with unresolved formula in has value > 0 Protect formula in cell? markg2 Excel 4 05-24-2010 11:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 AM.


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