Thread: Nested IF logic

Hi Everyone

I am desperately trying to figure out a formula that says

if one cell is more than 10% larger than the other then say increased, if it is more than 10% lower say decreased and if not say same ( Essentailly I only want to show change if it has been more that 10% in either direction.

this is my attempt that is not working !

=IF(E8-D8<10%,"Increase",IF(E8-D8>10%,"Decrease",IF(E8=D8,"Same",)))

With this formula I get these results, which i think are correct for the increase and desrease but if they are the same im getting 'increase'

100% 18% Increase
100% 100% Increase
100% 91% Increase
100% 82% Increase
70% 100% Decrease
100% 100% Increase
60% 82% Decrease
33% 73% Decrease
83% 73% Increase
33% 73% Decrease
100% 100% Increase
90% 100% 0
50% 100% Decrease
70% 100% Decrease

Plesae help Im driving myself nuts trying to use this formula. I have never been trained in Excel and learn as I go but this time i am confused !!!

Thank you
Claire

Claire, welcome to the board, however, please note that your original thread title fell foul of the Forum Rules.
Please try to keep the title specific to the problem - terms like "Help" etc don't really add value and detract from search facility.
Given first post etc I've modified on your behalf but going forward please be sure to post in adherence with the rules etc...

Regards your problem - an IF will exit upon first TRUE - it is thus imperative you order your tests correctly.

Originally Posted by picopooki

if one cell is more than 10% larger than the other then say increased, if it is more than 10% lower say decreased and if not say same ( Essentailly I only want to show change if it has been more that 10% in either direction.

Based on your requirements I suspect you should really be using:

=IF(E8-D8<-10%,"Increase",IF(E8-D8>10%,"Decrease","Same"))

In your original it follows that <10% would hold true wherever the >10% did not (with exception of 10% of course)