Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# Excel formula

### #1 getfothers Posted 31 January 2011 - 05:30 AM

getfothers

Member

• Member
• 15 posts
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
• 0

### #2 Vino Rosso Posted 31 January 2011 - 06:29 AM

Vino Rosso

Visiting Staff

• Visiting Consultant
• 235 posts
The formula you have seems to work...

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

 For two digit numbers

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

• 0

### #3 getfothers Posted 31 January 2011 - 06:35 AM

getfothers

Member

• Topic Starter
• Member
• 15 posts
Hi
Yes it does seem to work ?
Not sure why it didn't when i first tried it ?
Thanks Ian
• 0

### #4 RKinner Posted 02 February 2011 - 08:12 PM

RKinner

Malware Expert

• Expert
• 20,443 posts
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)
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users