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
|