HELP!! Trying to convert numbers.

  • Thread starter Thread starter Techie
  • Start date Start date
T

Techie

Here is my problem.

i have a series of 3 digit numbers that
need to be cinverted to a series of 4 digit
numbers using this following

722 needs to read as 5622 and in the next collum SV-7822
in the collum's to the right.
what type of formula is this and how can i do it?
The above is an example, i have a whole range of 3 digit numbers
that need the exact. rules applied to all numbers.
which is why i need a formula to do it.

Help someone please!!!!
 
I'm not completely clear on what your looking for but if 722 was in A1
in B1: = A1 + 4900
in B2: = ="SV-" & A1 + 7100

only works if #2 is always 4900 larger than #1 and #3 is always 7100 larger than #1

Also works
in B1: =ROUND(A1 * 7.78670360110803,0)
in B2: ="SV-" & ROUND(A1 * 10.8337950138504,0)

Not sure if thats what your looking for, but if not . . . you may want to provide a touch more detail

Dan E
 
Ok the 722 is the number i need to convert to
5622, and i also need to conver the 722
to SV-7822.
I need to apply the same rules
from numbers 110 to 999.
the common factor here is that whatever 3 digit numbers i have from
110 to 999 will drop the first digit down 1, and add a 5. so thats
why 722 turnes into 5622 .
another example is 550 should read 5450 & also SV-7650.
Hope this helps.
 
If those are the rules then from my first post

in A1: 722
in B1: = A1 + 4900
in C1: ="SV-" & A1 + 7100

will work

Dan E
 
Back
Top