Other than the cell not being wide enough, what do the multiple #.

D

Dave @ Metals USA

I have constructed an "If, Then, Else" statement with 8 possible findings.
The cell is now populated with multiple #'s. I have made sure the cell is
wide enough and am still seeing nothing but the #'s.

Please help!
 
C

CyberTaz

Just some thoughts-

What do you see in the Formula Bar when you select that cell?

Did you preceed the formula with an = ?

The ###'s indicate a formatted value which cannot be fully displayed due to
column width, so is it possible that the result of your formula simply needs
different formatting?

HTH |:>)
 
D

Dave Peterson

I've seen ###'s when I have negative numbers in a cell that's formatted as time
or date (and I'm not using the 1904 base date).

And I've seen ###'s when the value in the cell is numeric, but the format is
Number (say) and it won't fit. (Formatting as General will change the display
to Scientific--until the column is just too skinny to show even that.)

And I've seen ###'s when I had the long text in the cell and the cell was
formatted as Text. (Long text = 256 to 1024 characters).
 
Top