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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - MAKING THE FOLLOWING EQUATION DISPLAY A BLANK CELL IF NO DATA INPU (https://www.excelbanter.com/excel-discussion-misc-queries/84468-making-following-equation-display-blank-cell-if-no-data-inpu.html)

phill

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

SVC

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

Elkar

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

SteveG

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

Phill,

Change the zero to "".

HTH

Steve

--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=535036

All times are GMT +1. The time now is 09:03 PM.