IF function help - display certain character in blank cells

  • Thread starter Thread starter Melisa
  • Start date Start date
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??
 
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.
 
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).
 
Back
Top