Forum Discussion

David Harbin's avatar
David Harbin
Copper Contributor
Oct 02, 2018

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 appreciated

1 Reply

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor

    =IF((B1-A1)/A1>0,"increase",IF((B1-A1)/A1=0,"no change","decrease"))