Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-10-2014, 12:27 AM
macropod's Avatar
macropod macropod is offline Cell with unresolved formula in has value > 0 Windows 7 32bit Cell with unresolved formula in has value > 0 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your first formula outputs a number or null into H5. A null is not the same as no data and has a non-zero value. Accordingly, your subsequent formula needs to test for nulls (i.e. "") as well.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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 01:34 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