Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use the contents of a cell to satisfy the result_vector arg. | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |