Not @N/A, #N/A as in =IF(E60,E6,#N/A) or =IF(E60,E6,NA())
Jerry
Callan wrote:
Thanks, but where must I use it?
Here's the line I have in the cell
=If(E60,E6,"") I tried to put the @N/A instead of (""). Doesn't work.
If there is no value I need the cell to be empty so that the graph does not
represent it on the line.
Thanks
|