How to get a formula result to return either "+", "- ", or "="

[Scrubber]

Does anyone know of or how to craft a formula that calculates th
difference between the values in two columns, and then returns to
third column either a +, -, or = depending on whether value one is mor
than, less than or equal to value two?

Thank you

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Claus Busch]

Hi,

Am Wed, 18 Jul 2012 19:01:17 +0000 schrieb Scrubber:

Does anyone know of or how to craft a formula that calculates the
difference between the values in two columns, and then returns to a
third column either a +, -, or = depending on whether value one is more
than, less than or equal to value two?

try:
=IF(B1>A1,"+",IF(B1=A1,"=","-"))



Regards
Claus Busch

 

[Scrubber]

Here you go Jane.

I've even swapped it around so it actually does what I presume you mean
this time.

If it's NOW the wrong way round, just swap the < for > in the formula.

Let me know!

S.

EXACTLY! Thank you so very much

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[Spencer101]

EXACTLY! Thank you so very much!

Pleasure was all mine. Glad I could help.

:

+-------------------------------------------------------------------
+-------------------------------------------------------------------