How to add and subtract a number with percent

[trimi]

This is my situation: I have a table where I need to enter random general numbers (product costs) and subtract and/or add percentages. It has to do with a price sheet, I have a price to which I add VAT and/or subtract sale and rebate in % of different values. The 'sale' and 'rebate' fields are not fixed values, while the VAT is fixed.
(Office 2010) I attach image.
Thank you for your time and effort.
http://img256.imageshack.us/img256/9782/excelt.jpg

 

[tweedle]

Assuming your basis for VAT is the price after Rebate & Sale ...

Excel Workbook
	B	C	D	E	F	G	H
1	Units#	CPU$	SALE$	Rebate%	Sale%	VAT%	Price$
2	5.00	8.00	40.00	0%	0%	10%	44.00
3	5.00	8.00	40.00	10%	0%	10%	39.60
4	5.00	8.00	40.00	0%	10%	10%	39.60
5	5.00	8.00	40.00	10%	10%	10%	35.20
Sheet

 

[trimi]

Thank you Sir, this absolutely solves my problem!
Best regards,
p.s. how do I give u points.. is it possible in this forum?

 

[tweedle]

Nope, no points I know of.
Glad to help. Thanks for the post-back.