software

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

Assume...
Cell A2 - Full Price
Cell B2 - Tax
Cell C2 - Gratuity
Cell D2 - Total
-------------------------
B2 = A2 * .07
C2 = A2 * .15 lt;=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?''.quot;Slow Learnerquot; wrote:

gt; Hi there can someone help me...
gt; worksheet has 4 colums, column 1 contains full price of article (known
gt; amount), column 2 has tax amount (not always known), column 3 has gratuity
gt; amount (sometimes known), column 4 has total without tax but with gratuity.
gt;
gt; Tax, if unknown, is calculated at 7% of amount without gratuity.
gt;
gt; What would the formulas be to have my calculations become automatic on input
gt; of full amount?
gt;
gt; Thank you


I would add 1 more column which would be Column E and would be titled
quot;Total With Tax Gratuity.
Your Column D would then read as follows: =(A2 C2)
Then Column E would read as follows: =IF(B2=quot;quot;,(A2*7%) D2,(A2*B2) D2)
Which reads as follows: If B2 is Empty then A2*7% D2, IF False - Then
A2*B2 D2 this will give you the total of Cost Gratuity Tax.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=500762Try this:
in D1
=IF(A1gt;0,IF(B1gt;0,A1 (A1*B1) C1,A1 (A1*7%) C1),0)
copied down

A1 - amount
B1 - if left empty then the tax will be 7%, otherwise tax in B1
C1 - gratuity
D1 - total

Hope this helps!
JG

quot;Slow Learnerquot; wrote:

gt; Hi there can someone help me...
gt; worksheet has 4 colums, column 1 contains full price of article (known
gt; amount), column 2 has tax amount (not always known), column 3 has gratuity
gt; amount (sometimes known), column 4 has total without tax but with gratuity.
gt;
gt; Tax, if unknown, is calculated at 7% of amount without gratuity.
gt;
gt; What would the formulas be to have my calculations become automatic on input
gt; of full amount?
gt;
gt; Thank you

Oops.....misread your post a little, it should be:

=IF(A1gt;0,IF(B1gt;0,A1 B1 C1,A1 (A1*7%) C1),0)
copied down

A1 - amount
B1 - tax amount
C1 - gratuity
D1 - total
if B1 is not given then the tax will be 7% of A1

Regards
JG

quot;Slow Learnerquot; wrote:

gt; Hi there can someone help me...
gt; worksheet has 4 colums, column 1 contains full price of article (known
gt; amount), column 2 has tax amount (not always known), column 3 has gratuity
gt; amount (sometimes known), column 4 has total without tax but with gratuity.
gt;
gt; Tax, if unknown, is calculated at 7% of amount without gratuity.
gt;
gt; What would the formulas be to have my calculations become automatic on input
gt; of full amount?
gt;
gt; Thank you