> ???

P

Pank Mehta

It means greater than.

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

< means Less than

HTH

Pank
 
A

abfabrob

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...
 
B

Bart Snel

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...
 
A

abfabrob

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,
 
P

patrick

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
 
A

abfabrob

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...
 
Top