Excel

Question

I need to find a formula that will tell me how to calculate and automatically change the number of items and the left overs in singles rather than in fractions or percentages. As an example I have 235 items and they will be divided by lots of 25 so I will have 9.4 but the .4 doesn't work out to single items. The .4 should work out to 10 rather than the percentage. Can you help me?

Anonymous · Accepted Answer

If your A5 cell contains 235 and B5 cell contains 25 Then type following formula in cell C5 = Roundup(A5/B5,0) this will give you answer 10 .Other wise you can put formula in cell D5 as Roundup(C5,0)and in C5 put A5/B5

Related Topics:

1 Answer

Anonymous

Add Your Answer

Attachments: Added items

Ask a Question

Check Out the Mobile Browsers Report

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee

Grand Canyon Tech

Brad Brown

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Manuals & User Guides

Related Topics:

1 Answer

Anonymous

Add Your Answer

Attachments: Added items

Related Topics

Ask a Question

Popular Questions

Get message that "Setup cannot find Office.en-us\OfficeMUI.msi"

Hi i need micro soft visio 2010 product key

PROBLEM OF PRO11.MSI

HOW TO DOWNLOAD MS OFFICE 2007 FULL VERSION FREE

Confirmation code