Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    rounding (excel 2000)

    I have a cell, lets say is A1, where the result that is 3.66666, which I have it formatted to round this to 4. In another cell, I have a formula that takes the A1*5. I want it to take 4*5 and return 20, but excel takes the 3.6666*5. How can I change this?

    Rick

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: rounding (excel 2000)

    Try =ROUND(A1,0)*5
    Gre

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Columbus, Ohio
    Posts
    234
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Re: rounding (excel 2000)

    thanks...that did the trick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •