basic formula

[Guest]

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

 

[macropod]

Hi cjrolls.

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

Cheers

 

[Guest]

See if this works:

=IF(A1>B1,1,0)

Jaleel

 

[Bob Phillips]

=--A1>B1

--

HTH

Bob Phillips

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

 

[David Biddulph]

I think you'll need parentheses, Bob:
=--(A1>B1)