Thread: Excel - working out net and vat?
View Single Post
Old 09-01-2011, 00:19   #7
rogerdraig
cf.mega poster
 
Join Date: Mar 2005
Location: Wales
Posts: 2,509
rogerdraig has reached the bronze age
rogerdraig has reached the bronze agerogerdraig has reached the bronze agerogerdraig has reached the bronze agerogerdraig has reached the bronze agerogerdraig has reached the bronze agerogerdraig has reached the bronze agerogerdraig has reached the bronze agerogerdraig has reached the bronze age
Send a message via Yahoo to rogerdraig
Re: Excel - working out net and vat ???
if i get you right your entering the total and want the others to work out ?

if so

put the formula =SUM(E1/100)*82.5 in cell C2

and

put the formula =(E1/100)*17.5 in cell D2

lock both the cell then protect sheet
rogerdraig is offline   Reply With Quote