Formulas and Functions, Developer

%3CLINGO-SUB%20id%3D%22lingo-sub-1529825%22%20slang%3D%22fr-FR%22%3EFormulas%20and%20Functions%2C%20Developer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529825%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20guys%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20on%20an%20excel%20doc%20i'm%20working%20on.%3C%2FP%3E%3CP%3EI%20need%20to%20add%20a%20certain%20value%20to%20a%20cell%20everytime%20the%20user%20click%20on%20yes%2C%20and%20another%20value%20everytime%20the%20user%20click%20no.%3C%2FP%3E%3CP%3EI%20created%20the%20option%20case%20for%20the%20yes%20and%20no%20buttons%20and%20associated%20the%20values%20to%20add%20in%20each%20case.%20I%20am%20not%20sure%20about%20which%20function%20to%20use%20so%20that%20that%20value%20is%20added%20to%20the%20cell%20everytime%20the%20user%20click%20on%20any%20of%20the%20button.%3C%2FP%3E%3CP%3EIf%20you%20have%20any%20idea%20to%20share%20that%20would%20be%20amazing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529825%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello guys, 

 

I need help on a excel doc i'm working on.

I need to add a certain value to a cell everytime the user click on yes, and another value everytime the user click no.

I created the option case for the yes and no buttons and associated the values to add in each case. I am not sure about which function to use so that that value is added to the cell everytime the user click on any of the button.

If you have any idea to share that would be amazing.

 

Thank you

 

0 Replies