PPRuNe Forums - View Single Post - MS Excel Query
Thread: MS Excel Query
View Single Post
Old 11th May 2004 | 11:51
  #3 (permalink)  
The Nr Fairy
25 Anniversary
 
Joined: Nov 2000
Posts: 2,018
Likes: 73
From: Pewsey, UK
Or use "IF".

For example, =IF(A1=0,"",A1) will leave the cell blank if cell A1 is 0 otherwise it shows the correct value.
The Nr Fairy is offline