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

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

View Single Post

Old

05-29-2016, 03:33 AM

Philb1

Philb1 is offline

Philb1 uses Windows 10

Windows 10 Philb1 uses Office 2010 32bit

Philb1 uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

Join Date: Feb 2016

Location: Auckland

Posts: 43

Philb1 is on a distinguished road

Default

This will do that
=IF(ISBLANK(A1),"It's Blank","It's Not Blank")

Reply With Quote