IF formala -- true/false ... or equal???

[zimbielou]

I am working on a formula that needs to tell me the following:

If A>B then true
If A<B then false

BUT ALSO: if A=B then neither true or false (a third output)

Am I barking up the wrong tree with the IF formula? Will it only give me two outputs for greater than or less than? Is there a way to demonstrate a third output when A and B are equal?

Total Excel dummy here and could really use help.

Lindsey

 

[NBVC]

You can use a nested IF,

e.g. =IF(A1>B1,do this,IF(A1=B1,do this,do that))

Is this what you mean? If not, please specify your exact conditions (ie. what is to happen and when).

 

[zimbielou]

Yes. Exactly. Thank you so much!