Results 1 to 7 of 7

How to make the value on Microsoft Exel to end in 0.00 or 0.05.


This discussion is about "How to make the value on Microsoft Exel to end in 0.00 or 0.05." in the "Programming" forums.
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. #1
    C.I.A. etgo's Avatar
    Join Date
    Sep 2003
    Posts
    3,930

    Default How to make the value on Microsoft Exel to end in 0.00 or 0.05.


    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?

  2. #2
    C.I.A. silent-kill's Avatar
    Join Date
    Mar 2003
    Gender
    Male
    Posts
    2,838

    Default Re: How to make the value on Microsoft Exel to end in 0.00 or 0.05.

    format -> style -> modify -> number

  3. #3
    C.I.A. etgo's Avatar
    Join Date
    Sep 2003
    Posts
    3,930

    Default 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.

  4. #4
    Newbie
    Join Date
    Jul 2005
    Posts
    28

    Default 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.

  5. #5
    C.I.A. etgo's Avatar
    Join Date
    Sep 2003
    Posts
    3,930

    Default 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?

  6. #6
    Junior Member
    Join Date
    Aug 2005
    Posts
    368

    Default 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

  7. #7
    C.I.A. leo_trams's Avatar
    Join Date
    Jul 2005
    Posts
    4,428

    Default 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:

  8.    Advertisement

Similar Threads

 
  1. Replies: 749
    Last Post: 08-29-2010, 09:32 PM
  2. HELP How to make the MOST out of my life?
    By salami252001 in forum Relationships (Old)
    Replies: 30
    Last Post: 12-14-2009, 04:26 PM
  3. What do you suggest to make the World a Better place to Live??
    By cromagnon in forum Spirituality & Occult - OLDER
    Replies: 13
    Last Post: 07-10-2009, 10:20 AM
  4. How to know the spec on my Motherboard
    By grx in forum Computer Hardware
    Replies: 8
    Last Post: 03-12-2008, 04:57 PM
  5. How to change the Icon on your CD when you burn it
    By inspector_ronan in forum Software & Games (Old)
    Replies: 4
    Last Post: 07-12-2006, 04:13 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
about us
We are the first Cebu Online Media.

iSTORYA.NET is Cebu's Biggest, Southern Philippines' Most Active, and the Philippines' Strongest Online Community!
follow us
#top