Thread: basic formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 618
Default 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