basic formula
 

Hi
This is possibly very simple but for some reason I just dont get it. I have
3 columns
A B C
2 3 formula

A & B have numbers and in C I need a formula to say '1' if A is greater than
B and 0 if B is greater than A

Many thanks

basic formula
 

Hi cjrolls.

Try:
=(A1B1)^1
where A1 & B1 are your cell references.

Cheers

--
macropod
[MVP - Microsoft Word]


"cjrolls" wrote in message
...
Hi
This is possibly very simple but for some reason I just dont get it. I
have
3 columns
A B C
2 3 formula

A & B have numbers and in C I need a formula to say '1' if A is greater
than
B and 0 if B is greater than A

Many thanks

basic formula
 

See if this works:

=IF(A1B1,1,0)

Jaleel



"cjrolls" wrote:

Hi
This is possibly very simple but for some reason I just dont get it. I have
3 columns
A B C
2 3 formula

A & B have numbers and in C I need a formula to say '1' if A is greater than
B and 0 if B is greater than A

Many thanks

basic formula
 

=--A1B1

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"cjrolls" wrote in message
...
Hi
This is possibly very simple but for some reason I just dont get it. I
have
3 columns
A B C
2 3 formula

A & B have numbers and in C I need a formula to say '1' if A is greater
than
B and 0 if B is greater than A

Many thanks

basic formula
 

I think you'll need parentheses, Bob:
=--(A1B1)
--
David Biddulph

"Bob Phillips" wrote in message
...
=--A1B1

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"cjrolls" wrote in message
...
Hi
This is possibly very simple but for some reason I just dont get it. I
have
3 columns
A B C
2 3 formula

A & B have numbers and in C I need a formula to say '1' if A is greater
than
B and 0 if B is greater than A

Many thanks