0
In excel 2007 if cell A1 contains the number 12345 is there a formula to multiply the digits 1 x 2 x 3 x 4 x 5?
Wiki User
∙ 14y ago
=VALUE(LEFT(A1,1))*VALUE(MID(A1,2,1))*VALUE(MID(A1,3,1))*VALUE(MID(A1,4,1))*VALUE(RIGHT(A1,1))
VALUE - Converts a string to an integer
LEFT - Starts from the left and selects 1 character
MID - Starts at the second position and selects 1 character
RIGHT - Starts from the right and slects 1 character
You also could use VALUE(MID(A1,1,1) for the first value and VALUE(MID(A1,5,1) for the last value.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Number system contains -digits?
yes,number system contains digits..
What five digits number when you multiply by four is the same the number when you reversed it?
five digits number when you multiply by four is the same the number when you reversed it is 21978*4 = 87912
What number can multiply all numbers or digits?
the number one.
How will you multiply on a number line?
by moving each digits
How many digits in a tax exempt number?
The Tax Exempt number contains 11 Digits Altogether
How many digits does the largest prime number contains?
17,425,170 digits
When you multiply a 3 digit number by a 2 digit number what is the greatest number of digits the product can have?
It can have up to 5 digits.
'how many digits number system contains'?
There are 10 digits in our number system. The symbols 0,1,2,3,4,5,6,7,8,and 9 are the digits used to create numbers.
What two digit number if you multiply the digits are larger than the number itself?
17 \
I am an even number. I have three digits they are all the same. If you multiply me by 4 all the digits in the product are 8.?
222
What mass of sodium chloride contains 4.59 exp24 formula units?
To find the mass of sodium chloride containing 4.59 x 10^24 formula units, you can first calculate the molar mass of NaCl (58.44 g/mol). Then, use Avogadro's number (6.022 x 10^23 atoms/mol) to convert formula units to moles. Finally, multiply the number of moles by the molar mass to find the mass of sodium chloride.
How do you multiply three digits in a logical way?
Just multiply one pair of your numbers to give you a product, and then multiply their product by your third number.
