"0" Value Formula

UICOMP · #1 05-18-2012, 12:04 PM

What formula do I use to get a "0" value if the cell is blank?

CGM3 · #2 05-18-2012, 12:50 PM

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

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

UICOMP · #3 05-21-2012, 06:52 AM

Thank you!

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