Subtracting from a decimal number - strange question

**luu980** · 10-16-2018, 04:14 PM

I need to subtract a whole a number, which tells me how many digits to subtract from a decimal number. How do I do this?

It's better if i give an example:

Let's say, I need to first divide
Cell B18 by B22, = B18/B22

let's say the data entered will be
B18 = 36
B22 = .3

that equals 120

And, in cell C22, I have a number that has 3-5 decimal places.
Say, C22=1.92348

Now, the number 120 tells me, how many digits I need to subtract from 1.92348.

So the answer would be 1.92348 - 120 digits from the decimals, i.e. = 1.92228

The problem is not all the digits will be 5 decimal places, some will be 4, 3 or 2, etc. So for example, if the number on C22 is 1.92, then we will be subtracting 120 digits from 1.92 = .77

It's easy if it's always a certain number of decimal places. For example if two decimal places, then we can just make a set formula to turn the decimal number to a whole number then convert it back, say 1.92, would just be 1.92*100= 192-120 = 77. Then take the 77/100 = .77.

The problem is it's not always the same number of decimal places, so I can't make the formula always multiply by 100, 1000, or whatever it is to make it a whole number, then convert it back to a decimal.

How do I make the formula so it will do this calculation for me?

Sorry, I'm not good with excel. Thank you in advance for your help.

**protonLeah** · 10-16-2018, 06:15 PM

Start with:

Please Login or Register  to view this content.

**luu980** · 10-17-2018, 01:33 AM

Thank you very much. I'm not sure what you did, but it worked perfectly. Thank you again!

**AliGW** · 10-17-2018, 01:40 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

**luu980** · 10-17-2018, 02:04 AM

Sorry, I was mistaken.

It worked when C22=1.92348, but it didn't calculate it correctly when the C22 had a bigger whole number, such as C22=1265.2165

**AliGW** · 10-17-2018, 02:34 AM

Please do not post-edit posts that have had responses - it makes the thread hard to follow and breaks the sequence, making a nonsense of the thread. Instead, add a new post as you have now done. Your post-edited post has had its original text restored.

**Glenn Kennedy** · 10-17-2018, 03:08 AM

Try this:

=((C22*10^LEN(MID(C22,SEARCH(".",C22)+1,255)))-E19)/10^LEN(MID(C22,SEARCH(".",C22)+1,255))

**Phuocam** · 10-17-2018, 04:27 AM

Like this?

=C22-(B18/B22)/10^(LEN(C22)-FIND(".",C22))

**luu980** · 10-17-2018, 08:09 PM

AliGW: There was actually no one posted below my edited post except yours. It would have been a lot easier for you to delete your own post telling me to close the thread than to restore the original text of my edited post. You handled the situation incorrectly, but no matter.

Glenn Kennedy & Phuocam: both of your formulas seem to be working well for me now. Thank you very very much for your help. I really really appreciate you guys!!!

**Glenn Kennedy** · 10-18-2018, 01:58 AM

Y5ou're welcome.

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.

**AliGW** · 10-18-2018, 02:05 AM

You handled the situation incorrectly, but no matter.

You are entitled to your opinion, of course, however, you should not post-edit your posts in future, no matter how many posts are after them. Thank you for your co-operation.

**protonLeah** · 10-18-2018, 03:22 PM

.............

**AliGW** · 10-18-2018, 03:56 PM

See the second paragraph of post #9.

**luu980** · 10-19-2018, 12:56 AM

Originally Posted by AliGW

You are entitled to your opinion, of course, however, you should not post-edit your posts in future, no matter how many posts are after them. Thank you for your co-operation.

There is NO problem editing a post if there is no post after mine. Your request is completely illogical. You need to learn to moderate the forum better. Thank you for your cooperation.

@glenn reputation thing added! Thanks for showing me that option. I didn't know it existed! Again thank you and phuo for your help!

Subtracting from a decimal number - strange question

LinkBack

Thread Tools

Rate This Thread

Display

Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Re: Subtracting from a decimal number - strange question

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Strange Decimal Values? Rounding Error?

[SOLVED] copy number with 3 or more decimal places and paste the actual value as 2 decimal number

Strange behaviour decimal sign numeric keypad

[SOLVED] Adding and subtracting time above 24h (ten days) and converting to decimal

Subtracting time (in numbers) to decimal

[SOLVED] Decimal number to percentage formula (newbie question)

[SOLVED] Excel strange (erroneous?) decimal behaviour

SUBTRACTING TIME VALUES INSTEAD OF DECIMAL!!

Bookmarks

Bookmarks

Posting Permissions