how to display text when a cell>0 ?

[Janwillem]

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

[Paul B]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[Janwillem]

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


"Paul B" <[email protected]> wrote in message
news:uSOZb%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
> >
>
>

[Paul B]

Jan, works for me, did you put this in D1 or D7 as you said??? should work
in any cell , what error are you getting

--
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" <[email protected]> wrote in message
news:[email protected]...
> yes i already tried that, but i get the error that the function is
> incorrect.
>
>
> "Paul B" <[email protected]> wrote in message
> news:uSOZb%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> > >
> >
> >
>
>

[CLR]

Maybe you typed a letter "O" in the formula instead of a zero?

Paul's formula works fine........just copy and paste it out of his
response......

Vaya con Dios,
Chuck, CABGx3



"Janwillem" <[email protected]> wrote in message
news:[email protected]...
> yes i already tried that, but i get the error that the function is
> incorrect.
>
>
> "Paul B" <[email protected]> wrote in message
> news:uSOZb%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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
> > >
> > >
> >
> >
>
>