0
It depends how you need to display the result. For example - say you have a list of five prices in column 1 starting at cell A10 - you want to show the amount of VAT charged (at 20%) in column 2 and the total price in column 3...
In cell B10 type the formula =sum(A10*0.20)
In cell C10 type the formula =sum(A10*1.20)
Then - copy both B10 & C10 together and paste them into cells B11 to B14 (inclusive) - if you've copied the conents of B10 & C10 - the folmula from C10 should copy down to C14.
As a test... type the following data into A10 to A14 respectively...
...A.........B.........C
27.10 - 5.42 - 32.52
12.51 - 2.50 - 15.01
11.81 - 2.36 - 14.17
36.42 - 7.28 - 43.70
19.87 - 3.97 - 23.84
Column A is your test data. Column B is the amount of VAT (at 20%) and Column C is the total including VAT. NOTE - the hyphens and dots in the table above are JUST for clarity !
You can change the figures in the formulae to any you want to.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
How many icolumns in openoffice calc?
You can have a maximum of 2292 columns in an OpenOffice spreadsheet.
Do you have to register OpenOffice Calc every time you open the program?
No - OpenOffice does not require registration of any kind.
What are cells in OpenOffice?
A "cell" is a single field in the spreadsheet application 'Calc'
Is it true That OpenOffice Calc cannot save xls files?
False ! Open Office Calc is quite happy to save files in .xls format !
How many columns in OpenOffice Calc?
The maximum number of collums available is 2292.
Does open office give you the ability to create a spreadsheet?
Absolutely - I use them regularly. The spreadsheet part of OpenOffice is 'Calc'
How do you divide and multiply from one cell to another in openoffice calc?
You would use a formula such as ... =sum(a3/10) or =sum(b12*a3)
How many cells are there in calc openoffice?
The maximum number of rows is 1048576 and the maximum columns is 2292. Therefore the total number of cells available is 2,403,315,564 !
Which OpenOffice you can use to make calendars?
You could use the Calc program. I did one for a friend last using Open Office Calc. I designed the background etc, and used fomule in the spreadsheet to change the date by one day to the required number each month.
What software programs come included in OpenOffice?
It includes :- Base - Database Calc - Spreadsheet Draw - Design Impress - Presentation Math - Formula editor Writer - Word-processor
How can you calculate melting point of subliming solid?
Impossible to calc any melting or boiling points.
what is the like excel type program you mentioned one morning sounded something like PREZI.COM?
Please check out openoffice at http://www.openoffice.org/. Open Office Calc is a spreadsheet program very similar to Excel.
