G
Guest
Text in cells are plotted as zeros in Excel 2003 with Windows XP.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jerry W. Lewis
Use #N/A instead of text.
Jerry
Jerry
G
Guest
I have multiple columns and enter tradiing (commodity) date daily. Formulae
are in the columns which become values when the daily data is entered. I
have been using Lotus and am trying with difficulty to convert to Excel
are in the columns which become values when the daily data is entered. I
have been using Lotus and am trying with difficulty to convert to Excel
J
Jerry W. Lewis
Formulas must return sumething (Excel has no missing or empty cell
value). Anything other than a number or a #N/A will plot as zero.
Either write an event driven macro to add the formula only when the data
is available, or else use a formula like
=IF(INUMBER(dailyData),formula,#N/A)
as I suggested yesterday. You can use a conditional format to hide the
display of error values in the cells if the worsksheet appearance
bothers you.
Jerry
value). Anything other than a number or a #N/A will plot as zero.
Either write an event driven macro to add the formula only when the data
is available, or else use a formula like
=IF(INUMBER(dailyData),formula,#N/A)
as I suggested yesterday. You can use a conditional format to hide the
display of error values in the cells if the worsksheet appearance
bothers you.
Jerry
G
Guest
Thank you. However I must be doing somethng wrong and I just foound it. I had
not copied the formulae to the end of the date. All is well. The work
appearance does not bother me. Thanks
Dozier
not copied the formulae to the end of the date. All is well. The work
appearance does not bother me. Thanks
Dozier