# 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

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

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

4. Phill,

Change the zero to "".

HTH

Steve

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1