| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to format a cell adding 17.5% VAT excel
Hi have made a spreadsheet up with Net totals. How do I make cell underneath
show total + 17.5 % VAT Thanks in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to format a cell adding 17.5% VAT excel
If total is in A10, then =A10*.175 would give you the VAT amount.
-- Brevity is the soul of wit. "The Red Devil" wrote: Hi have made a spreadsheet up with Net totals. How do I make cell underneath show total + 17.5 % VAT Thanks in advance |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to format a cell adding 17.5% VAT excel
Net amaount in D7, formula in D8:
=D7*1.175 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings with @tiscali.co.uk "The Red Devil" <The Red wrote in message ... Hi have made a spreadsheet up with Net totals. How do I make cell underneath show total + 17.5 % VAT Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, conditional format (font red) referencing another cell? | Excel Worksheet Functions | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
