| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I take a number from a cell and mult each digit by
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I take a number from a cell and mult each digit by
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I take a number from a cell and mult each digit by
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 wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I take a number from a cell and mult each digit by
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" wrote in message ... 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 wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I take a number from a cell and mult each digit by
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 ... 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" wrote in message ... 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 wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I take a number from a cell and mult each digit by
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 ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How to validate a cell to insert from 9 digit number to 13 digit number. | Excel Worksheet Functions | |||
| How do I seperate a 10 digit number into one cell for each number? | Excel Discussion (Misc queries) | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
![greyhound girl[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
