Microsoft Office Forums - View Single Post - [Solved] How to prevent #DIV/0!

Thread: [Solved] How to prevent #DIV/0!

View Single Post

Old

05-31-2016, 06:40 PM

jparnold

jparnold is offline

jparnold uses Windows XP

Windows XP jparnold uses Office 2010 32bit

jparnold uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

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