Need formula to add function

[Jack-P-Winner]

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

 

[Asheesh]

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)

 

[Jack-P-Winner]

It

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)

It may, I'm having brain lock on how to write the formula lol

 

[NARAYANK991]

Hi Larry ,

Another possibility would be :

=MOD(cell value,10)

so that any multiple of 10 will be replaced by 0.

Similarly :

=MOD(D7+D8,10)

will return 0.

Narayan

 

[Jack-P-Winner]

Hi Larry ,

Another possibility would be :

=MOD(cell value,10)

so that any multiple of 10 will be replaced by 0.

Similarly :

=MOD(D7+D8,10)

will return 0.

Narayan

Perfect , Thanks Narayan