• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need formula to add function

I want whatever number I add together that equals 10 to be a 0.

For example, 5+5=0 6+4=0, D7 and D8 I want to equal a 0 not a 10

Thank you
 

Attachments

  • Reverse Numberv1.xlsx
    9.8 KB · Views: 5
Hey Jack,

whats up...

Isn't the simple If function helping you, provided I understand your question right :)

I mean if(logic =10,0,whatever you want)
 
Back
Top