Forum Discussion
David Harbin
Oct 02, 2018Copper Contributor
Excel
This may be too simple for the group but it has me beat, I am looking for a formula that compares column A1 to column B1 and gives a "no change", "increase" or "decrease" result. any help greatly a...
Matt Mickle
Oct 02, 2018Bronze Contributor
=IF((B1-A1)/A1>0,"increase",IF((B1-A1)/A1=0,"no change","decrease"))