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
Bookmarks