How do I take a number from a cell and mult each digit by

's Computer Specifications

I need to take the number entered into a cell and then take each digit of
that number and multiply it by another. Can this be done outside of coding?

's Computer Specifications

"greyhound girl" <greyhound (E-Mail Removed)> skrev i en
meddelelse news:E84D21EF-A19E-4658-A364-(E-Mail Removed)...
>I need to take the number entered into a cell and then take each digit of
> that number and multiply it by another. Can this be done outside of
> coding?

One way:

=PRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))

The formula is an array formula and must be submitted with
<Shift><Ctrl><Enter>, also if edited later.

--
Best regards
Leo Heuser

Followup to newsgroup only please.

's Computer Specifications

If you want to multiply them all by 1

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))

If some other number, say 7

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(ROW(INDIRECT("1:"&L
EN(A1)))^0*7))

If by some set of weightings, such as 56432684

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(MID("56432684",ROW(
INDIRECT("1:"&LEN(A1))),1)))

or if using those weightings aligned (i.e. final digit by 4, previous by 8,
etc.)

=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(MID("56432684",LEN(
"56432684")-ROW(INDIRECT("1:"&LEN(A1)))+1,1)))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"greyhound girl" <greyhound (E-Mail Removed)> wrote in message
news:E84D21EF-A19E-4658-A364-(E-Mail Removed)...
> I need to take the number entered into a cell and then take each digit of
> that number and multiply it by another. Can this be done outside of
coding?

's Computer Specifications

Hi Bob,

just this one -

> If some other number, say 7
>
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(ROW(INDIRECT("1:"&L
> EN(A1)))^0*7))

why not simply -

=SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))*7)

Regards,
Peter T

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If you want to multiply them all by 1
>
> =SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))
>
> If some other number, say 7
>
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(ROW(INDIRECT("1:"&L
> EN(A1)))^0*7))
>
> If by some set of weightings, such as 56432684
>
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(MID("56432684",ROW(
> INDIRECT("1:"&LEN(A1))),1)))
>
> or if using those weightings aligned (i.e. final digit by 4, previous by
8,
> etc.)
>
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(MID("56432684",LEN(
> "56432684")-ROW(INDIRECT("1:"&LEN(A1)))+1,1)))
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "greyhound girl" <greyhound (E-Mail Removed)> wrote in
message
> news:E84D21EF-A19E-4658-A364-(E-Mail Removed)...
> > I need to take the number entered into a cell and then take each digit
of
> > that number and multiply it by another. Can this be done outside of
> coding?
>
>

's Computer Specifications

or even without the VALUE(...) or a --

=SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*7)

Regards,
Peter T

"Peter T" <peter_t@discussions> wrote in message
news:(E-Mail Removed)...
> Hi Bob,
>
> just this one -
>
> > If some other number, say 7
> >
> >
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(ROW(INDIRECT("1:"&L
> > EN(A1)))^0*7))
>
> why not simply -
>
> =SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))*7)
>
> Regards,
> Peter T
>
> "Bob Phillips" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > If you want to multiply them all by 1
> >
> > =SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)))
> >
> > If some other number, say 7
> >
> >
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(ROW(INDIRECT("1:"&L
> > EN(A1)))^0*7))
> >
> > If by some set of weightings, such as 56432684
> >
> >
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(MID("56432684",ROW(
> > INDIRECT("1:"&LEN(A1))),1)))
> >
> > or if using those weightings aligned (i.e. final digit by 4, previous by
> 8,
> > etc.)
> >
> >
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(MID("56432684",LEN(
> > "56432684")-ROW(INDIRECT("1:"&LEN(A1)))+1,1)))
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "greyhound girl" <greyhound (E-Mail Removed)> wrote in
> message
> > news:E84D21EF-A19E-4658-A364-(E-Mail Removed)...
> > > I need to take the number entered into a cell and then take each digit
> of
> > > that number and multiply it by another. Can this be done outside of
> > coding?
> >
> >
>
>

's Computer Specifications

I think I got bogged down in thinking of equal array sizes?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Peter T" <peter_t@discussions> wrote in message
news:(E-Mail Removed)...
> Hi Bob,
>
> just this one -
>
> > If some other number, say 7
> >
> >
>
=SUMPRODUCT(--(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),--(ROW(INDIRECT("1:"&L
> > EN(A1)))^0*7))
>
> why not simply -
>
> =SUMPRODUCT(VALUE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))*7)
>
> Regards,
> Peter T

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to validate a cell to insert from 9 digit number to 13 digit number.	ramulu via OfficeKB.com	Microsoft Excel Worksheet Functions	1	21st Feb 2007 02:32 PM
How to validate a cell to insert from 9 digit number to 13 digit number.	ramulu	Microsoft Excel Worksheet Functions	1	21st Feb 2007 10:00 AM
How do I seperate a 10 digit number into one cell for each number?	=?Utf-8?B?VGtyaWdlcg==?=	Microsoft Excel Misc	2	26th Jan 2007 04:29 PM
each number in cell should be 10 digit	=?Utf-8?B?VmlwdWw=?=	Microsoft Excel Worksheet Functions	2	2nd Nov 2006 11:32 AM
Color a single digit in a mult-digit number cell	=?Utf-8?B?UGh5bGxpcw==?=	Microsoft Excel Misc	6	17th Nov 2005 12:46 AM