Re: how to display text when a cell>0 ?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

yes i already tried that, but i get the error that the function is
incorrect.


"Paul B" <to_much_spam_to_list@xxxxxxxxxx> wrote in message
news:uSOZb%23jfFHA.2484@xxxxxxxxxxxxxxxxxxxxxxx
> Jan, try this, =IF(B1>0,A1,"")
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "Janwillem" <jw@xxxxxxxxxxxxx> wrote in message
> news:42c53e6d$0$1261$ba620dc5@xxxxxxxxxxxxxxxxxxxxxx
> > Hi there.
> >
> > i have something like this:
> >
> > A B C D
> > 1 hello 1
> > 2 test 0
> > 3 bye 1
> >
> >
> > Now i want to display hello at D7 when B1>0
> >
> > So the output should be:
> >
> > A B C D
> > 1 hello 1 hello
> > 2 test 0
> > 3 bye 1 bye
> >
> > How can i do this?
> >
> > thanks,
> >
> > Jan Willem
> >
> >
>
>


.

Relevant Pages

  • Re: increment invoice numbers in excel
    ... Paul B ... Always backup your data before trying something new ... Please post any response to the newsgroups so others can benefit from it ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: pyparsing 1.3.2 released
    ... common, but incorrect, quotation. ... Prev by Date: ...
    (comp.lang.python)
  • Re: Using a list as an IF answer
    ... Paul B ... Always backup your data before trying something new ... > I've tried typing in the following ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: extracting text data in a cell
    ... Paul B ... Always backup your data before trying something new ... Please post any response to the newsgroups so others can benefit from it ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Why cant I insert comments on my spreadsheet?
    ... Pennyb9, is the sheet protected, what happens when you try to insert one? ... Paul B ... Always backup your data before trying something new ... Prev by Date: ...
    (microsoft.public.excel.misc)