How to prevent #DIV/0!

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

FAQ

Thread Tools

Display Modes

05-28-2016, 06:41 PM

jparnold

Windows XP How to prevent #DIV/0!

Office 2010 32bit

Advanced Beginner

Join Date: Jan 2012

Location: Blue Mountains, NSW, Australia

Posts: 41

How to prevent #DIV/0!

I am wondering how to insert a formula into a cell which will display a blank result when the values in the cells being accessed are blank.

For example I have formula of =F4/C4*100 which displays #DIV/0! when (cells) F4 and or C4 are blank.

Thanks

« Previous Thread | Next Thread »

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 03:25 PM.