"0" Value Formula

		Microsoft Office Forums > Microsoft Excel > Excel
"0" Value Formula

05-18-2012, 12:50 PM

CGM3

Windows XP "0" Value Formula

Office 2007

Advanced Beginner

Join Date: Oct 2009

Posts: 38

=IF(A1="",0,A1)

Of course, you'll use whatever cell is appropriate rather than A1.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
using merge fields in "if then else" formula	mike0919	Mail Merge	4	03-27-2013 02:50 PM
How to edit the "Format" and the "show level" of an EXISTING table of content?	Jamal NUMAN	Word	2	08-14-2011 10:46 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Excel 07 formating 17 cells "Need Formula"	Raner	Excel	2	05-30-2010 02:07 PM
"Microsoft Excel Application" missing in the "Component Services" on win08	sword.fish	Excel	0	02-26-2010 02:09 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:48 PM.