How to calculate percentages using Open Office Calc spreadsheet

[@stewarttaylor5522]

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]

Cool 😎 thanks 👍

[@brizzell2101]

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.

[@dcpwebdesigners]

Thanks 😎 More Open Office 4 Tutorials: kzbin.info/aero/PLRpn_0jbcinvBC_9_E1XUjpYwFVAnEKuH

[@dcpwebdesigners]

More Libre Office Tutorials: kzbin.info/aero/PLRpn_0jbcintTnKYPFW8D7Lg4UgAoX8kZ

[@dcpwebdesigners]

Check out my new blog for latest free video tutorials: www.dcpweb.co.uk/blog/type/2/videos Have fun learning new skills :) #share #knowledge #dcpweb

[@qualitycarpetcare8122]

Just what i was looking for

[@dcpwebdesigners]

Cool :)

[@gillestessier5950]

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

[@dcpwebdesigners]

Interesting 🤓 i will try to give that a go, should be possible

[@thijseijk25]

Have you already figured out how to do that? It was the same I was looking for

[@marleyshouseofsport9068]

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!

[@dcpwebdesigners]

1st column contains base number, 2nd column contains 1st formula, 3rd contains 2nd formula

[@ArnoldVeeman]

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

[@dcpwebdesigners]

Just tested agian and works ok , make sure you follow all steps in Tutorial

[@Incantationem]

I had the same thing happen when using comma instead of point to signify decimals.

[@Venserql]

@@Incantationem I had to use comma, with a point it wouldn't work.

[@Incantationem]

@@Venserql Probably some regional setting somewhere.

[@inspiretalks9800]

Thanks

[@dcpwebdesigners]

Cool 😃