How to make the value on Microsoft Exel to end in 0.00 or 0.05. murag lisod sabton da.. example nalang.
ex.
5.9375 X 210 = 1,246.88 (round off to two decimal places). ang gusto nako it will be 1,246.85 or 1,246.90. posible bani?
Results 1 to 7 of 7
-
09-19-2005, 10:32 AM #1C.I.A.
- Join Date
- Sep 2003
- Posts
- 3,914
How to make the value on Microsoft Exel to end in 0.00 or 0.05.
-
09-19-2005, 11:41 PM #2C.I.A.
- Join Date
- Mar 2003
- Gender
- Posts
- 2,837
Re: How to make the value on Microsoft Exel to end in 0.00 or 0.05.
format -> style -> modify -> number
-
09-20-2005, 10:40 AM #3C.I.A.
- Join Date
- Sep 2003
- Posts
- 3,914
Re: How to make the value on Microsoft Exel to end in 0.00 or 0.05.
thanks, pero di man bai. iya man e round off to 1,246.88.
-
09-21-2005, 01:01 PM #4Newbie
- Join Date
- Jul 2005
- Posts
- 28
Re: How to make the value on Microsoft Exel to end in 0.00 or 0.05.
yes bai,
possible kaau na bai,
gamit og lookup, try the condition CHANGING in the lookup. from FORMAT in menubar.
-
09-22-2005, 02:13 PM #5C.I.A.
- Join Date
- Sep 2003
- Posts
- 3,914
Re: How to make the value on Microsoft Exel to end in 0.00 or 0.05.
wala kay ko ka kuha bai da.. pwede explain more bai?
-
09-24-2005, 03:42 PM #6Junior Member
- Join Date
- Aug 2005
- Posts
- 368
Re: How to make the value on Microsoft Exel to end in 0.00 or 0.05.
Assuming the cell you want to round off is A1, use:
=ROUND(A1*20,0)/20
-
04-15-2006, 10:23 AM #7C.I.A.
- Join Date
- Jul 2005
- Posts
- 4,202
Re: How to make the value on Microsoft Exel to end in 0.00 or 0.05.
bring this up...
create a function which will read two digits to the right of your decimal value.
That created function should be able to do the conversion.
ang mahitabo...inig butang nimo sa imo function i.e., imbes =ROUND(x1,y)
ang imo ...myFunc(x1,y) where y could be 0 or 5.
gets?
hmmm, a little knowledge in macro/vb will do.
just use the help files in excel to learn the basics. :mrgreen:
Reply With Quote Advertisement
Similar Threads |
|
Posting Permissions
|