What does > mean in a formula?
--
Rob,
Teesside,
UK
What does > mean in a formula?
--
Rob,
Teesside,
UK
It means greater than.
i.e. A>B would equate to A greater than B.
< means Less than
HTH
Pank
"abfabrob" wrote:
> What does > mean in a formula?
> --
> Rob,
> Teesside,
> UK
I though I was a newbie :-)
Bigger than; A>B means A is bigger than B.
Bart Snel
"abfabrob" <[email protected]_SPAM> schreef in bericht
news:[email protected]...
> What does > mean in a formula?
> --
> Rob,
> Teesside,
> UK
How does everyone know so much about excel? It confuses me!
Thanks for your help today,
--
Rob,
Teesside,
UK
"Bart Snel" wrote:
> I though I was a newbie :-)
>
> Bigger than; A>B means A is bigger than B.
>
> Bart Snel
>
> "abfabrob" <[email protected]_SPAM> schreef in bericht
> news:[email protected]...
> > What does > mean in a formula?
> > --
> > Rob,
> > Teesside,
> > UK
>
>
>
I've always found that the more I know about something, the more I realise
how little I know. In that light, your confusion tells me you've learned a
lot today!
Welcome.
Bart Snel
"abfabrob" <[email protected]_SPAM> schreef in bericht
news:[email protected]...
> How does everyone know so much about excel? It confuses me!
>
> Thanks for your help today,
> --
> Rob,
> Teesside,
> UK
>
>
> "Bart Snel" wrote:
>
>> I though I was a newbie :-)
>>
>> Bigger than; A>B means A is bigger than B.
>>
>> Bart Snel
>>
>> "abfabrob" <[email protected]_SPAM> schreef in bericht
>> news:[email protected]...
>> > What does > mean in a formula?
>> > --
>> > Rob,
>> > Teesside,
>> > UK
>>
>>
>>
I have indeed! Except for the #DIV/0! error. think I will just leave it in
there. The cell still displays the correct answer when data is entered, so no
worries.
Thanks again,
--
Rob,
Teesside,
UK
"Bart Snel" wrote:
> I've always found that the more I know about something, the more I realise
> how little I know. In that light, your confusion tells me you've learned a
> lot today!
>
> Welcome.
>
> Bart Snel
>
> "abfabrob" <[email protected]_SPAM> schreef in bericht
> news:[email protected]...
> > How does everyone know so much about excel? It confuses me!
> >
> > Thanks for your help today,
> > --
> > Rob,
> > Teesside,
> > UK
> >
> >
> > "Bart Snel" wrote:
> >
> >> I though I was a newbie :-)
> >>
> >> Bigger than; A>B means A is bigger than B.
> >>
> >> Bart Snel
> >>
> >> "abfabrob" <[email protected]_SPAM> schreef in bericht
> >> news:[email protected]...
> >> > What does > mean in a formula?
> >> > --
> >> > Rob,
> >> > Teesside,
> >> > UK
> >>
> >>
> >>
>
>
>
This error appears when the formula is dividing by 0 or a blank cell.
As soon as you enter data in the formula target cell, you will get the
correct result. You can eliminate the error from showing for blank cells by
using an IF statement. eg. =If(A1>1,Your formula,"") The"" is a Null. So
the IF statement reads, If A1 is not blank, then do your formula, If A1 is
blank, then show a blank! This hides your #DIV/0 error.
Excel is a wonderful tool and I agree the more you learn about it the less
you know. Have fun with it.
Pat F
"abfabrob" wrote:
> I have indeed! Except for the #DIV/0! error. think I will just leave it in
> there. The cell still displays the correct answer when data is entered, so no
> worries.
>
> Thanks again,
> --
> Rob,
> Teesside,
> UK
>
>
> "Bart Snel" wrote:
>
> > I've always found that the more I know about something, the more I realise
> > how little I know. In that light, your confusion tells me you've learned a
> > lot today!
> >
> > Welcome.
> >
> > Bart Snel
> >
> > "abfabrob" <[email protected]_SPAM> schreef in bericht
> > news:[email protected]...
> > > How does everyone know so much about excel? It confuses me!
> > >
> > > Thanks for your help today,
> > > --
> > > Rob,
> > > Teesside,
> > > UK
> > >
> > >
> > > "Bart Snel" wrote:
> > >
> > >> I though I was a newbie :-)
> > >>
> > >> Bigger than; A>B means A is bigger than B.
> > >>
> > >> Bart Snel
> > >>
> > >> "abfabrob" <[email protected]_SPAM> schreef in bericht
> > >> news:[email protected]...
> > >> > What does > mean in a formula?
> > >> > --
> > >> > Rob,
> > >> > Teesside,
> > >> > UK
> > >>
> > >>
> > >>
> >
> >
> >
That so worked, thank you!
--
Rob,
Teesside,
UK
"patrick" wrote:
> This error appears when the formula is dividing by 0 or a blank cell.
> As soon as you enter data in the formula target cell, you will get the
> correct result. You can eliminate the error from showing for blank cells by
> using an IF statement. eg. =If(A1>1,Your formula,"") The"" is a Null. So
> the IF statement reads, If A1 is not blank, then do your formula, If A1 is
> blank, then show a blank! This hides your #DIV/0 error.
> Excel is a wonderful tool and I agree the more you learn about it the less
> you know. Have fun with it.
> Pat F
>
> "abfabrob" wrote:
>
> > I have indeed! Except for the #DIV/0! error. think I will just leave it in
> > there. The cell still displays the correct answer when data is entered, so no
> > worries.
> >
> > Thanks again,
> > --
> > Rob,
> > Teesside,
> > UK
> >
> >
> > "Bart Snel" wrote:
> >
> > > I've always found that the more I know about something, the more I realise
> > > how little I know. In that light, your confusion tells me you've learned a
> > > lot today!
> > >
> > > Welcome.
> > >
> > > Bart Snel
> > >
> > > "abfabrob" <[email protected]_SPAM> schreef in bericht
> > > news:[email protected]...
> > > > How does everyone know so much about excel? It confuses me!
> > > >
> > > > Thanks for your help today,
> > > > --
> > > > Rob,
> > > > Teesside,
> > > > UK
> > > >
> > > >
> > > > "Bart Snel" wrote:
> > > >
> > > >> I though I was a newbie :-)
> > > >>
> > > >> Bigger than; A>B means A is bigger than B.
> > > >>
> > > >> Bart Snel
> > > >>
> > > >> "abfabrob" <[email protected]_SPAM> schreef in bericht
> > > >> news:[email protected]...
> > > >> > What does > mean in a formula?
> > > >> > --
> > > >> > Rob,
> > > >> > Teesside,
> > > >> > UK
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks