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.
What else can I help you with?
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 do you hide zero values in OpenOffice calc?
To hide zero values in OpenOffice Calc, you can go to the menu and select "Tools," then "Options." Under "OpenOffice Calc," choose "View" and check the box for "Zero values" to hide them. Alternatively, you can use a custom number format by selecting the cells, right-clicking to choose "Format Cells," and then entering a format like 0;-0;;@, which will display numbers normally but hide zeros.
How many columns in OpenOffice Calc?
The maximum number of collums available is 2292.
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 !
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 do Change picture Alignment in OpenOffice Calc?
To change picture alignment in OpenOffice Calc, first select the image you want to adjust. Then, right-click on the image and choose "Position and Size" from the context menu. In the dialog that appears, you can adjust the alignment settings under the "Position" tab, specifying horizontal and vertical alignment options. After making your adjustments, click "OK" to apply the changes.
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
