I want to Round-up a number in a cell

**Sally T.** · 05-18-2013, 01:25 PM

Question #1: I'm Averaging cells c39:Aj39 and putting the answer in an39. I want to Round-up to two numbers after the decimal point. How do I accomplish this task?
Question #2: I have created a pie chart but I'm having problems. I have selected A30:A38 as my titles and O30:O38 for my values. I'm doing this to show my income. All titles show up and all but one value shows up and it simply shows a 0%. Its piece of the pie is exactly the right size and when I add up all of the other pieces, the correct value remains for the one showing 0%. The worksheet has the correct value in the cell. Please Help!

**shg** · 05-18-2013, 01:28 PM

1. =ceiling(average(C39:AJ39), 0.01)

2. I don't do pie charts

**Sally T.** · 05-18-2013, 02:04 PM

Awesome, shg!!! I knew nothing about the ceiling command, but I sure will look into it and get familiar with it. Thanks! By the way, it worked! Too bad you couldn't help with the pie chart. Will someone else be able to help?

**Pepe Le Mokko** · 05-18-2013, 03:08 PM

Always best to ask one question per thread.
I suppose shg doesn't do pie charts because of their limitations / bad perception / flaws

**Sally T.** · 05-18-2013, 03:27 PM

Thanks for responding, Pepe! Are you familiar with Pie Charts? I have created a pie chart but I'm having problems. I have selected A30:A38 as my titles and O30:O38 for my values. I'm doing this to show my income. All titles show up and all but one value shows up and it simply shows a 0%. Its piece of the pie is exactly the right size and when I add up all of the other pieces, the correct value remains for the one showing 0%. The worksheet has the correct value in the cell. Please Help!

**ChemistB** · 05-21-2013, 09:20 AM

Can you upload an example with some dummy data? (Go Advanced>Manage Attachments) (Note: that would be an example spreadsheet, not a picture of a spreadsheet)