How to prevent #DIV/0!

		Microsoft Office Forums > Microsoft Excel > Excel
How to prevent #DIV/0!

05-29-2016, 03:33 AM

Philb1

Windows 10 How to prevent #DIV/0!

Office 2010 32bit

Advanced Beginner

Join Date: Feb 2016

Location: Auckland

Posts: 43

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
prevent repetition in form	johnbest	Word VBA	2	03-31-2015 11:42 PM
Prevent Copying and Pasting	Jimmy Tsawo	Excel	3	02-20-2014 03:54 AM
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 05:48 AM.