Forum Statistics
- Forum Members:
- Total Threads:
- Total Posts: 5
There are 1 users currently browsing forums.
|
 |
06-30-2009, 07:53 AM
|
|
Registered User
|
|
Join Date: 30 Jun 2009
Location: london,england
MS Office Version:Excel 2007
Posts: 2
|
|
how to make excel multiply numbers with 3 decimals?
Please Register to Remove these Ads
Ok, my english is lousy but i will try to explain somehow.
This is the calculation I have made in excel
1152,31*0,15=172,85
And this is one made with ancient accounting calculator my boss uses:
1152,31*0,15=172,84
You get the picture? 
So, I work with taxes and I have loads of calculation to do. Is there any way to set up excel so it can calculate numbers like this(automatically with two decimals) because my boss believes only in his ancient calculator...
If anyone knows, please hurry, I have a deadline in 2 days...
|
06-30-2009, 07:57 AM
|
 |
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,517
|
|
|
Re: how to make excel multiply numbers with 3 decimals?
That number is rounded down from 172,8465....
Excel has a Rounddown() function...
=Rounddown(number,decimals)
e.g. =Rounddown(1152,31*0,15;2)
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
06-30-2009, 08:11 AM
|
|
Registered User
|
|
Join Date: 30 Jun 2009
Location: london,england
MS Office Version:Excel 2007
Posts: 2
|
|
|
Re: how to make excel multiply numbers with 3 decimals?
OK THANX!! NOW,
i have one more small request. I have 3 major formulas and i have managed to insert rounddown to 2 of them. I need a little help with third...
=(IF(H5<540;(0);(IF(G5<9000;((G5-3600)*0,25);(5400*0,25)))))
|
06-30-2009, 08:18 AM
|
|
Forum Guru
|
|
Join Date: 06 Dec 2006
Location: Mississauga, CANADA
MS Office Version:2003 & 2007
Posts: 18,517
|
|
|
Re: how to make excel multiply numbers with 3 decimals?
Try:
=ROUNDDOWN(IF(H5<540;0;IF(G5<9000;((G5-3600)*0,25);(5400*0,25)));2)
__________________
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to my reputation by clicking the icon next to the Post # in the bar above my avatar (picture) in this post.
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
|
06-30-2009, 09:19 AM
|
 |
Forum Guru
|
|
Join Date: 23 Jun 2007
Location: London,England
MS Office Version:office 97 ,2003 ,2007
Posts: 6,084
|
|
|
Re: how to make excel multiply numbers with 3 decimals?
Quote:
|
because my boss believes only in his ancient calculator...
|
get him to do it manually! then he will see the calculator is erronous.
1152.31*0.15
=115231 *10^-2 * 15*10^-2
=115231 *15 *10^-2*10^-2
=115231 *15 *10^-4
115231
x 15
-------
576155
1152310
-----------
1728465
1728465 x 10^-4 =172.8465
if he can't do that he shouldnt be your boss!
|
|
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
