# MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU

1. ## 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

MANY THANKS  Register To Reply

2. ## RE: MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU

Replace the 0 with two double quotes ("").

"phill" wrote:

> 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  Register To Reply

3. ## RE: MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU

Yup, just change the 0 to a double-quotes ""

HTH,
Elkar

"phill" wrote:

> 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  Register To Reply

4. Phill,

Change the zero to "".

HTH

Steve  Register To Reply