[getfothers]

I want to create a check sum for Mod10 and it needs a calculation like "=IF(D7>9,"sum(LEFT(d7,1))+RIGHT(d7,1)",D7)".
To explain what I am try to achieve
If the result of a previous formula is 10 or more then the digits are added together eg 14 added together is 5 and 18 added together is 9 (It can never be higher than 18)
If the sum is less than 10 (9 or lower) then it is left alone

any suggestions ?
Thanks
Ian

[Advertisements]

The formula you have seems to work...

=IF(D7>9,SUM(LEFT(D7,1)+RIGHT(D7,1)),D7)

[Edit] For two digit numbers

Edited by Vino Rosso, 31 January 2011 - 06:31 AM.

[Vino Rosso]

The formula you have seems to work...

=IF(D7>9,SUM(LEFT(D7,1)+RIGHT(D7,1)),D7)

[Edit] For two digit numbers

Edited by Vino Rosso, 31 January 2011 - 06:31 AM.

[getfothers]

Hi
Yes it does seem to work ?
Not sure why it didn't when i first tried it ?
Thanks Ian

[RKinner]

Looks to me like your original formula had a paren in the wrong place.

=IF(D7>9,"sum(LEFT(d7,1) ==> ) <== +RIGHT(d7,1)",D7)