IF function help - display certain character in blank cells

M

Melisa

I have a worksheet that someone wants to have all the
blank cells in the range display a "0" and the other cells
to display whatever is in them. I have tried to figure
out an IF function, but don't know what to put for the
false part. Is there a way to have it just display what
is in the cell as the false??
 
T

tclohesy

I suppose what you meant was to have IF(A1="",0,A1) in the A1 cell, so
where 'A1' appears in the formula, replace it with whatever the
original formula was.
 
D

Dave Peterson

If you want to display 0's, you're going to have to fill those empty cells with
0's.

If that's ok, a quick way to fill the empty/blank cells in a range is:

Select the range
F5 (ctrl-G or edit|goto)
click the Special button
click Blanks
type 0
hit ctrl-Enter (instead of just enter)

Excel will fill the current selection with what you typed. And the current
selection was limited to just the blank cells using the edit|goto|special stuff.

This is a neat way to fill empty cells with formulas, too. xl will adjust the
formula just liked you dragged it down (or copied and pasted).
 
Top