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

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!

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 |:)

"Dave @ Metals USA" wrote:

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!

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).



Dave @ Metals USA wrote:

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!

--

Dave Peterson

Excel's Help for the IF worksheet function says:

"Up to seven IF functions can be nested ..."

- Mike
www.mikemiddleton.com

"Dave @ Metals USA" <Dave @ Metals wrote in
message ...
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!