Assume...
Cell A2 - Full Price
Cell B2 - Tax
Cell C2 - Gratuity
Cell D2 - Total
-------------------------
B2 = A2 * .07
C2 = A2 * .15 <=assume 15% gratuity
D2 = A2 + C2




--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Slow Learner" wrote:

Hi there can someone help me...
worksheet has 4 colums, column 1 contains full price of article (known
amount), column 2 has tax amount (not always known), column 3 has gratuity
amount (sometimes known), column 4 has total without tax but with gratuity.

Tax, if unknown, is calculated at 7% of amount without gratuity.

What would the formulas be to have my calculations become automatic on input
of full amount?

Thank you