How to calculate percentages using Open Office Calc spreadsheet

In this video tutorial, I will show you how to calculate percentages using Open Office Calc spreadsheet. Save yourself some time and use formulas to calculate percentages for small or big data sets.

#OpenOffice #Calc #dcpweb

Contact me on:

calculate percentages, calculate percentages using Open Office Calc spreadsheet, calculate percentages using Open Office, calculate percentages in open office, calculate percentages open office, open office calculate percentages, open office spreadsheet calculate percentages, calculate percentages open office spreadsheet, calculate percentages using open office spreadsheet, open office percentage calculations, percentage calculations open office

[stewarttaylor]

Thanks for taking time to explain this in simple easy to understand language. I knew how to do it on a calculator, but wanted an easy way to do it on a spreadsheet. Cheers :)

[dcpwebdesigners]

Have fun learning new skills :)

#share #knowledge #dcpweb

[brizzell]

Thank you for talking and not writing out everything. Thank you for not blasting us with offensive amped techno no one likes. Got more coding like this? I'm budgeting based on % of my income.

[marleyshouseofsport]

I've never understood how this kind of thing works and you've been able to help me understand in a way I can use it. So for that thank you. AMAZING stuff. What I actually need to do (and I do this daily) is calculate for example... 10% of a number (multiple numbers like you have going down and dragging the black dot to do it for 500 different balances) but then I also want to add that 8.4% to the original number's total. So in the example of 100 I need 10% of it being 10 then I want that 10 added to the 100 = 110 total. Is it possible to do all of that within one formula applied to a cell? And then I can drag the black dot down and have that applied to a whole bunch? What would that formula then be? I also want to do the same only minus the percentage off the initial balance. If you could help with this you'll be literally saving me hours and hours every day!

[gillestessier]

What I'd reaaly want to get is the percentage of a result to another result. ie: % of sum(A1:A10) on sum(B1:B10). Tks for helping

[ArnoldVeeman]

but it doesn't work . . . I got an "NAME?" error message. What can I do?