Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding logical values
|
#2
|
|||
|
|||
They are probably text-formatted if a text function has created them as in:
=LEFT(A1,2) while A1 houses something like 215 or 21A. =--LEFT(A1,2) or =LEFT(A1,2)+0 would make the result a true number. Veronique wrote: I tried to add a range of cells which values came from a function and the result was 0. It didn't seem to understand the result of my function as a true number. any hint on how to add this range of cells? Thanks much, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
project values based on other values | Excel Discussion (Misc queries) | |||
Save External Link Values | Excel Discussion (Misc queries) |