| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
HOW DO I SHOW VAT CONTENT
trying to set up a spreadsheet and final column must show vat content but
can't work it out |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
HOW DO I SHOW VAT CONTENT
Assuming you have the total price in D2 then you can use
=D2-D2/(1+17.5%) to get the VAT Since we are dealing with money you might want to add ROUND to it =ROUND(D2-D2/(1+17.5%),2) -- Regards, Peo Sjoblom "josudare" wrote in message ... trying to set up a spreadsheet and final column must show vat content but can't work it out |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| How to transpose formulas from column content to row content. | Excel Worksheet Functions | |||
| How to show cell content in the toolbar for editing? | Excel Worksheet Functions | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
| How do I show break in bar graph to show large and small numbers | Charts and Charting in Excel | |||
Linear Mode
