MHB Difficult Question on decimal placing

  • Thread starter Thread starter Elementry
  • Start date Start date
AI Thread Summary
The discussion revolves around finding a software solution, particularly in Excel, to manipulate decimal numbers by extracting and combining digits from both sides of the decimal point. The user seeks to select specific digits from the right and left of the decimal, such as transforming 1234.45 into 445 or 3445. Suggestions include using mathematical operations like multiplying by powers of 10 to move the decimal and employing the int() function to isolate digits. The conversation emphasizes the need for clarity on the data format being used. Overall, the thread highlights a programming approach to achieve the desired decimal manipulation.
Elementry
Messages
1
Reaction score
0
Hi All,

Trying to find a program or (excel) or any software which allows you to cross over both sides of the decimal place. I want to extract left and right of the decimal and add in rules . I can't seem to find any programs to do this.
Any help would be good.

1. entering a number say - 1234.45

i would like to do two things, select the right side decimal numbers plus the 1st left placing. = 445 beocmes the number

And i woudl like to be able to extract the next decimal over so 1234.45 becomes 344.5 .

im not sure what this is called or how to achcieve it in excel or any math program , any help would be good.

PS - obviously id like to be able to go 2 left placing and two right combined so the example above would be : 1234.45 would be 3445

appreaciate any help or idea what this type of math is called or comes under

thkx
 
Mathematics news on Phys.org
Hello Elementry,

I have moved this topic, as it is more of a programming question than one of mathematics, although some basic math is involved.

To move the decimal point, multiplying by a power of 10 will do the trick. A positive power moves it to the right, while a negative power moves it to the left.

Then, to strip off the digits to the right of the decimal point, you could use the int(x) function intrinsic to most programming languages, known as the floor or greatest integer function in mathematics, to accomplish this. For example:

1234.45 - int(1234.45) = 0.45

Will your data always have the format xxxx.xx?
 
Seemingly by some mathematical coincidence, a hexagon of sides 2,2,7,7, 11, and 11 can be inscribed in a circle of radius 7. The other day I saw a math problem on line, which they said came from a Polish Olympiad, where you compute the length x of the 3rd side which is the same as the radius, so that the sides of length 2,x, and 11 are inscribed on the arc of a semi-circle. The law of cosines applied twice gives the answer for x of exactly 7, but the arithmetic is so complex that the...
Back
Top