View Single Post
  #6   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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