3 conditions returning 1 result

[DebBagby]

I have 2 columns I want to compare.
A1 contains value 1
A2 contains value 2
A3 contains the result

If A1 is larger than A2 the result is "Down".
If A2 is larger than A1 the result is "Up".
If A1 is equal to A2 the result is "No Change".

Seems simple enough but for the life of me I can only find solutions for 2 of the 3 conditions.

Thank you for your help.

Deb Bagby

[Andrew-R]

Try:

=IF(A1>A2,"Down",IF(A2>A1,"Up","No change"))

[DebBagby]

formula.jpgReturns a "Down" where there should be a "No Change".

[Andrew-R]

Then the two values aren't identical - are they formatted to 2 decimal places, or similar?

[DebBagby]

You're correct! I'm working off someone elses spreadsheet and didn't realize they had decimals in there breaking it down.

Thank you for your help!