basic formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cjrolls - 21 Nov 2006 12:17 GMT

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

Reply to this Message

macropod - 21 Nov 2006 12:34 GMT

Hi cjrolls.

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

Cheers

Signature

macropod
[MVP - Microsoft Word]

> Hi
> This is possibly very simple but for some reason I just dont get it. I have
[quoted text clipped - 6 lines]
>
> Many thanks

Reply to this Message

Jaleel - 21 Nov 2006 12:35 GMT

See if this works:

=IF(A1>B1,1,0)

Jaleel

> Hi
> This is possibly very simple but for some reason I just dont get it. I have
[quoted text clipped - 6 lines]
>
> Many thanks

Reply to this Message

Bob Phillips - 21 Nov 2006 13:21 GMT

=--A1>B1

--

HTH

Bob Phillips

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

> Hi
> This is possibly very simple but for some reason I just dont get it. I have
[quoted text clipped - 6 lines]
>
> Many thanks

Reply to this Message

David Biddulph - 21 Nov 2006 19:41 GMT

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

Signature

David Biddulph

> =--A1>B1
>
[quoted text clipped - 18 lines]
>>
>> Many thanks

Reply to this Message