Jump to content

Welcome to Geeks to Go - Register now for FREE

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
Photo

Excel formula


  • Please log in to reply

#1
getfothers

getfothers

    Member

  • Member
  • PipPip
  • 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

Advertisements


#2
Vino Rosso

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)

[Edit] For two digit numbers

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

  • 0

#3
getfothers

getfothers

    Member

  • Topic Starter
  • Member
  • PipPip
  • 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

RKinner

    Malware Expert

  • Expert
  • 17,350 posts
  • MVP
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

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP