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
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
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
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
Phill,
Change the zero to "".
HTH
Steve
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks