#1
|
|||
|
|||
"0" Value Formula
What formula do I use to get a "0" value if the cell is blank? |
#2
|
|||
|
|||
=IF(A1="",0,A1)
Of course, you'll use whatever cell is appropriate rather than A1. |
#3
|
|||
|
|||
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 |