Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 05-31-2016, 06:40 PM
jparnold jparnold is offline How to prevent #DIV/0! Windows XP How to prevent #DIV/0! Office 2010 32bit
Advanced Beginner
How to prevent #DIV/0!
 
Join Date: Jan 2012
Location: Blue Mountains, NSW, Australia
Posts: 41
jparnold is on a distinguished road
Default

Lovely!
Works just the way I prefer. If the input cells contain nothing (clear), or a space or zero (0) then it returns a blank (ie clear)
I have not seen that logical operator before ie N()
Please explain.
Thanks again
John
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
prevent repetition in form johnbest Word VBA 2 03-31-2015 11:42 PM
How to prevent #DIV/0! Prevent Copying and Pasting Jimmy Tsawo Excel 3 02-20-2014 03:54 AM
How to prevent #DIV/0! How can I PREVENT headings I don't want? peytontodd Word 3 11-23-2013 05:08 PM
Prevent Overlap of Appointments irab88 Outlook 0 08-03-2010 10:43 AM
text box, prevent from printing Tanya Word 0 02-05-2010 06:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:30 PM.


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