"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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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