Blank result

[vinayjan]

Hi,

i have a formula as below:
=HLOOKUP($B200,Scheduler!$E$2:$GT$124,SUM(1+$E$1),0)= Result 0

if the result is 0 this should show as Blank in current cell instead showing zero. Important is Only the result zero this field show as blank.

Could you please check and help me.

Thanks in advance!!

[mehmetcik]

Just wrap an if statement around your formula.

Please Login or Register  to view this content.

[AZ-XL]

Try this:
=if(HLOOKUP($B200,Scheduler!$E$2:$GT$124,SUM(1+$E$1),0)=0,"",HLOOKUP($B200,Scheduler!$E$2:$GT$124,SUM(1+$E$1),0))

[Tony Valko]

Maybe one of these...

If the formula normally returns a TEXT value:

=T(HLOOKUP($B2,Scheduler!$E$2:$GT$124,SUM(1+$E$1),0))

If the formula normally returns a NUMERIC value:

=IFERROR(1/(1/HLOOKUP($B2,Scheduler!$E$2:$GT$124,SUM(1+$E$1),0)),"")

[vinayjan]

Thank you All!!! Its working fine

[Tony Valko]

You're welcome. We appreciate the feedback!