Thread: MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
phill
 
Posts: n/a
Default MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU
HI

=IF(ISNA(VLOOKUP(B38,AF1:AG121,2,FALSE)),0,VLOOKUP (B38,AF1:AG121,2,FALSE))

IS THERE ANYWAY THAT THE ZERO IN THIS EQUATION CAN BE CHANGED SO THAT IT
DISPLAYES A BLANK CELL INSTEAD?

MANY THANKS
Reply With QuoteReply With Quote