> ???

  • Thread starter Thread starter Guest
  • Start date Start date
It means greater than.

i.e. A>B would equate to A greater than B.

< means Less than

HTH

Pank
 
I though I was a newbie :-)

Bigger than; A>B means A is bigger than B.

Bart Snel
 
How does everyone know so much about excel? It confuses me!

Thanks for your help today,
--
Rob,
Teesside,
UK


Bart Snel said:
I though I was a newbie :-)

Bigger than; A>B means A is bigger than B.

Bart Snel
Click to expand...
 
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 said:
How does everyone know so much about excel? It confuses me!

Thanks for your help today,
Click to expand...
 
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,
 
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
 
That so worked, thank you!
--
Rob,
Teesside,
UK


patrick said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What does { } mean in excel formulas? 4
What does "" mean in Excel? 2
What does -- symbol mean in an excel formulae eg: SUMPRODUCT(--(A1:A10="Luke 3
what do these ----> {0.6,2,4,5,6,7,9} and {0,21,111,201,551,1101,2701}means in an excel formula? 1
How to subtract a number from a Mergefield? 0
what does "^" symbol mean in excel 2
What does is mean when I see a "+" beginning a formula 3
Trendline formula 6

Back
Top