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

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

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