Re: Empty Cell Result

Why do you think Mike wants that since he says?

"I would like the 3rd parameter to not return "", not return 0 but return
NOTHING. Is there a way to return empty, blank, etc?"

To me it sounds as though he wants a truly empty cell which cannot be done
through a formula since the cell holds the formula


--


Regards,


Peo Sjoblom




"Pranav Vaidya" <PranavVaidya@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:188EB4E1-6C36-48F3-BCDF-223F8E9BE7EE@xxxxxxxxxxxxxxxx
That;s right..but then how about changing the cell type to Custom and then
setting it to #, by this even if there is a zero, it will not be
displayed.

I agree this will work only for display purpose, which what I think Mike
wants.
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"JE McGimpsey" wrote:

No. Formulae always return values to their calling cells.

You could replace the formulas with an Event Macro.

Or there may be alternatives, depending on what you're using the results
for.


In article <055D80DD-0148-4632-8D75-539035059325@xxxxxxxxxxxxx>,
Mike H. <MikeH@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

In this if statement: IF(A1=100,1,"") I would like the 3rd parameter
to not
return "", not return 0 but return NOTHING. Is there a way to return
empty,
blank, etc?



.

Relevant Pages

  • RE: Formula help
    ... Glad I could help, Mike. ... D1 is not equal to nothing, or then not equal to an empty cell. ... figure out how Excel would trap conditions. ...
    (microsoft.public.excel.misc)
  • Re: CPCC video stream
    ... Mike, You seem like a decent guy but could you stop putting down the ... I am a decent guy. ... I merely commented that the streaming video didn't ... really show people and the show looked empty based on the video. ...
    (alt.smokers.pipes)
  • Re: RS-422 bus
    ... normally the UART asserts when it's shift register is empty (and not when ... the last bit has left the chip). ... Mike ...
    (microsoft.public.windowsce.embedded)
  • Re: Data Manipulation and buffering
    ... modified record one at a time deciding whatever you need to do. ... Mike wrote: ... > I am using table buffering. ... > Do I need to give something like 'Delete from tablename where Empty( ...
    (microsoft.public.fox.programmer.exchange)
  • Re: select rows until empty found
    ... Dim pIndex as long ... Dim pRange as Word.Range ... 'Find row with empty cell in column 2 ... As it is the code will fail if there are no empty ...
    (microsoft.public.word.tables)
Quantcast