True or False Formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi Everyone. I've just got myself Excel and I'm trying to create a simple
spreadsheet.

What I need to do is have C calculated automatically. I have searched Google
for a hint, but I don't know Excel that well enough yet plus English is my
second language.

A1>B1=C1

If A is greater than B, C is the answer.

1>5=False
1>0=True
1>1=Equal or 0 from what I read

Very much thanks to anyone who can help learn this.

Joanne Ramirez
 
Hello. I have worked out part of my probelm and realized I need help with
more. I am trying to learn this.

=(A1>B1)OR(A1<B1)OR(A1=B1)

Is it true, false or the same.

Something like this I need. I'm not sure how to do this.

Thankyou very much.
 
Hi!

Not exactly sure what you want but try one of these and
see if it works.

This most closely resembles your explanation.

=IF(OR(A1="",B1=""),"",IF(A1=B1,"same",A1>B1))

This is another possible interpretation:

=IF(OR(A1="",B1=""),"",IF(A1=B1,"equal",IF
(A1>B1,"greater","less")))

The only suggestion I have is if A1>B1 is TRUE, then A1<B1
has to be FALSE so there's no need to test for the
opposite condition.

Biff
 
Hello Biff. Thank you very much. It worked first go. You have helped me very
much :)

Have a good Christmas.
Jo
 
Back
Top