0
On iwork spreadsheet how do you make a column calculate VAT eg column 1 type in 100 then column 2 would automatically calculate vat and column 3 would automatically calculate total inc vat?
Wiki User
∙ 14y ago
If the 100 is in cell A3 and the VAT rate is 15%, then in cell B3 you would have the following formula:
=A3*15%
However it is better to put the VAT rate into a cell by itself, like perhaps in cell B2. Then the formula would be as follows, with the dollar symbols enabling the formula to be copied while keep using the 15%.
=A3*$B$2
Then in C3 you would have the following formula to get the total:
=A3+B3
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Is apple iwork numbers a spreadsheet program?
Apple's Numbers software is the spreadsheet component of their iWork suite.
What does iWork have in it?
iWork is made up of three applications: * Pages - the word processor * Numbers - the spreadsheet * Keynote - for presentations
What is the name of apple's spreadsheet software?
The spreadsheet included with the iWork software suite is called Numbers.
What are five examples of spreadsheet?
Some examples of spreadsheet application software are the following:Openoffice.org CalcMicrosoft Office ExcelGoogleDocsGnumericApple iWork NumbersLotus 1-2-3
What is included with Apple iWork?
Apple iWork is similar to the Windows Office Suite. It features a spreadsheet, word processor, database and drawing tools. You can also play movies from iTunes.
What do the iwork software does?
iWork is made up of three applications: • Pages - the word processor which does word processing • Numbers - the spreadsheet which does numerical stuff • Keynote - which is used for creating presentations (See links below)
What is an example of spreadsheet software?
Visicalc (Very Old - first ever electronic spreadsheet?)Lotus 1-2-3Apple iWork NumbersMicrosoft ExcelOpenOffice.org CalcGoogle Docs Spreadsheet
What do you call the office productivity suitein mac os x?
iWork It includes word processor: Pages, spreadsheet, Numbers, and presentation: Keynote.
You already have iwork 08 installed and you want to try out iwork 09. will you lose or damage iwork 08 if you install the iwork 09 trial?
iWork 09 is installed into it's own iWork 09 folder in the Applications folder. It should not touch an iWork 08 installation.
What is office productivity suite in mac OS X?
Apple's office productivity sweet is called "iWork." It includes a spreadsheet, presentation software, and page layout application.
When was IWork created?
IWork was created on 2005-01-11.
Will IWorks 06 files be able to be opened in a newer version of IWorks?
All previous iWork files are readable by late copies of iWork but upon opening them you have to save them to the new format of that version of iWork. For example an iWork '06 document opened in iWork '08 will have to be saved as an iWork '08 document upon opening it, which means you will not be able to open it in a previous version of iWork
