answersLogoWhite

0

choose where you want to show the vat

type =

click on the cell you want to add vat to

type +0.175*

then click on the cell you want to add vat to

example - =Z1+0.175*Z1

hope this helps

(its a formula by the way!)

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

Why did Microsoft add the x to the file extension for Excel?

To indicate that the basic file format is XML in Excel 2007 and later.


What is a file extension for Microsoft Excel?

For a standard Excel document, prior to Excel 2007, it is xls and xlsx is used in 2007. There are other kinds of files created by Excel, like templates which can be xlt or macros which can be xlm and xla for Add-ins, and there are other extenions. For 2007, you add x to the end of them.


How do you add a set of numbers together on excel 2007?

=sum(first cell:last cell)


How many columns in 2003 and 2007?

In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.In Excel 2003 there are 256 columns. In Excel 2007 there are 16384 columns.


How Excel 2007 Converted to Excel 2003?

You can open a 2007 Excel spreadsheet with Excel 2003 if you save the file in Excel 2007 using "Save As" and select the 2003 compatibility mode.


Can you use Excel 2010 as Excel 2007?

The differences between them are not extensive so you can work in Excel 2010 easily if you are familiar with Excel 2007. You can save your files so that Excel 2007 will recognise them.


How can insert name to cells in MS-Excel?

Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.Select the cell or cells you want to apply a name to. Then for versions of Excel up to 2003, go to the Insert Menu and pick name. You can then add a name for your selection. For versions of Excel from 2007 onward, you can do it through the Name Manager which is on the Formulas ribbon.


How do you add a new row or column in Microsoft Excel 2007?

Right click where you want to insert and an Insert option appears.


Can you change the Excel 2007 toolbars to look like Excel 2003 and earler versions?

There is no direct option available to convert MS Excel 2007 look and feel changed to MS excel 2003. However, you can customized the MS Excel 2007 to your need. Click on MS Office icon on top right hand side corner. Click on MS ExcelOptions. Click on Customize and add the icon/command as per your needs. Regards, Sarfaraz Ahmed


When you save a document in Excel what does it save as?

It will save it with the name you specify and as the default type of workbook for the version of Excel you have. You should give the file a name, but if you don't it will call it Book1 and then add the appropriate extension. For the more modern versions, which is Excel 2007 onwards, that would be .xlsx, but if you are using an older version than Excel 2007, then it would be .xls instead.


Is vlookup present in Excel 2007?

Yes, VLOOKUP is still in Excel 2007 and 2010.


When was sumifs introduced to Excel 2008 or 2007?

The SUMIFS function was introduced in Excel 2007.

Trending Questions
What command would you use to ping a host with the ip address 192.168.5.36? Which home wireless router is the most reliable Linksys Dlink Belkin or Netgear? What is the ram from a laptop? When would it be more efficient to use SMB to transfer files instead of FTP? Why choose Windows 2000 Server instead of Windows 2000 Professional? I have a toshiba Qosmio x305-701. Was just wondering if I can upgrade the CPU or if it's integrated.? Where can one find an Imacros for sale? Is it worth buying software that claims it will speed up my PC? What is a common type of memory card? Is learning science is useful to humans? How do you get rid of a Trojan horse downloader 5 istbar removal tried with multiple resources reappears at every power up and lauches all programs? Is a browser input or output? What button is used in the spelling dialog box after you selected a word from the list you want to include in the presentation? Does a single-user system supports multiprogramming? Where is deleted data saved in a computer? Your gigabyte ga8ipe775pro motherboard has2 blue and2 grey ram slots ddr will only work in blue slots says it is dual ram will ddr2 work in it? How to delete search browser dropbox? Windows cannot log you on because your profile cannot be loaded Check that you are connected to the network or that your network is functioning correctly? What is an arrangement of text or numbers in rows and columns similar to a spreadsheet? Where can one find free Joomla templates?