Ask Experts Questions for FREE Help !
Ask
    Liliwen's Avatar
    Liliwen Posts: 2, Reputation: 1
    New Member
     
    #1

    Jun 8, 2012, 05:19 AM
    Excel 'roundup' How do I?
    I have a list of figures.. they a various and I need to calculate 50% in a separate column which I have done. I now need to feed the resulting list into a rather antiquated system in order to process the service I am providing.

    The problem is this (my) system will not accept a number that returns as 3.125 (50% of 6.25 of course) in the fx window even though the actual cell reads 3.13 once I formatted the list to accounting and 2 decimal spaces. I can manually change each occurrence in the list of course but knowing how amazing excel is think there must be another way to globally amend the whole list.

    I have dabbled with the 'roundup' function, looked briefly at 'ceiling' but neither has so far worked.

    Any ideas would be hugely appreciated
    Liliwen's Avatar
    Liliwen Posts: 2, Reputation: 1
    New Member
     
    #2

    Jun 8, 2012, 07:23 AM
    Ah... I have answered my own question! It is 'Roundup' but I did not realise you could use the 'fill' function to copy it to the whole column... doh! Done that, copied and pasted values only over the top and job done! Phew...

    Thanks anyway to all who have looked and thought about answering!

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to connect one excel sheet to other excel sheet [ 28 Answers ]

How to connect one excel sheet to other excel sheet.

IF with ROUNDUP help please? [ 6 Answers ]

I am struggling to make this formula work. It seems to round up to 1 or 0, but not to 2 or 3. I would really appreciate any advice. =IF(B29<1,0,ROUNDUP(((B29/Input!$C$3/Input!$C$19/Schedule!B30)-B35)>0,0))

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Does Roundup really kill crabgrass? [ 2 Answers ]

I have an area about 20 feet by 30 feet that is infested with crabgrass. It's about 99 percent crabgrass and 1 percent centipede grass. I was told that Roundup would kill the crabgrass. What I wanted to do is completely kill everything in this area and just resod it, hoping that new sod...

Puppy got into Roundup. [ 5 Answers ]

Hi, the family puppy which is a Golden Retriever/Lab/Shepard X found an empty container of roundup out on my parents farm. My dad does not know where she found it, but he caught her chewing on it, and yelled at her. She's 10 months old now, and he said that she was throwing up and wouldn't eat...


View more questions Search