Forum Discussion

Leah Argento's avatar
Leah Argento
Copper Contributor
Jun 08, 2018

Help With Formula Error

 20172018% Diff
January   
Signature$1,241$0-100%
Boosters$0$894#DIV/0!
Total$1,241$0-100%
    

 

What should my formula for "Boosters" be to return the correct % Diff of 100% ?

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Leah,

     

    let's hope your former math teacher will not read this.

    100% of 0 is ... 0! Not 894.