1. Welcome to TechPowerUp Forums, Guest! Please check out our forum guidelines for info related to our community.

Excel formatting question?

Discussion in 'General Software' started by tilldeath, Oct 29, 2012.

  1. tilldeath New Member

    Joined:
    Feb 8, 2011
    Messages:
    200 (0.16/day)
    Thanks Received:
    7
    So I have a total amount in cell D16, then below that I need to input a formula that is 1/4 of cell D16. What do I enter here? =D16/.25??????? It gives me a fractional value and I need it in decimal Ie.106 7/8 I need it to come out 106.875 with it rounded to 106.88. Any help?
  2. micropage7

    micropage7

    Joined:
    Mar 26, 2010
    Messages:
    5,563 (3.55/day)
    Thanks Received:
    1,269
    Location:
    Jakarta, Indonesia
    what about format cell>number and setting number from that
  3. newtekie1

    newtekie1 Semi-Retired Folder

    Joined:
    Nov 22, 2005
    Messages:
    19,646 (6.23/day)
    Thanks Received:
    5,830
    This should work:
    Code:
    =ROUND((D16/4), 2)
    Crunching for Team TPU 50 Million points folded for TPU
  4. 1freedude

    1freedude

    Joined:
    Nov 16, 2007
    Messages:
    557 (0.23/day)
    Thanks Received:
    118
    also, your math is wrong. It would be d16*.25
  5. drdeathx

    drdeathx

    Joined:
    May 14, 2009
    Messages:
    2,132 (1.13/day)
    Thanks Received:
    479
    Location:
    Chicago burbs
    D16*.25

    Your welcome
  6. tilldeath New Member

    Joined:
    Feb 8, 2011
    Messages:
    200 (0.16/day)
    Thanks Received:
    7
    thx guys, =D16*.25 worked fine but kept giving me a fractional answer until I changed the formatting to dollars and then it converted it to decimal. Feel semi retarded:nutkick:

Currently Active Users Viewing This Thread: 1 (0 members and 1 guest)

Share This Page