Needing help with a Function on Excel.

E

Ezoriel

Hey guys. I'm having a bit of problems figuring out the correct functio
to use for what I'm needing it for. Starting on column A2 through A 4
is a list of paycheck amounts. I need column B to show how much in taxe
was removed from each row, at 30%. For example if Column A2 has 800.00
Column B2 should read 240.00. Also, I'd like for Column C2 to have th
final amount from the Tax reduction. For example if A2 is 800.00, and i
B2 the taxes taken out is 240.00, then Column C2 should read 560.00.

If anyone can help me out, I'd greatly appreciate it
 
S

Spencer101

Ezoriel;1604197 said:
Hey guys. I'm having a bit of problems figuring out the correct functio
to use for what I'm needing it for. Starting on column A2 through A 4
is a list of paycheck amounts. I need column B to show how much in taxe
was removed from each row, at 30%. For example if Column A2 has 800.00
Column B2 should read 240.00. Also, I'd like for Column C2 to have th
final amount from the Tax reduction. For example if A2 is 800.00, and i
B2 the taxes taken out is 240.00, then Column C2 should read 560.00.

If anyone can help me out, I'd greatly appreciate it.

B2 would be *=A2*0.3*
and C2 would be *=A2-B2*
Then copy down as necessary.

Simple as that..
 
C

Claus Busch

Hi Ezoriel,

Am Tue, 31 Jul 2012 02:57:54 +0000 schrieb Ezoriel:
Hey guys. I'm having a bit of problems figuring out the correct function
to use for what I'm needing it for. Starting on column A2 through A 40
is a list of paycheck amounts. I need column B to show how much in taxes
was removed from each row, at 30%. For example if Column A2 has 800.00,
Column B2 should read 240.00. Also, I'd like for Column C2 to have the
final amount from the Tax reduction. For example if A2 is 800.00, and in
B2 the taxes taken out is 240.00, then Column C2 should read 560.00.

your thinking wrong.
Column A is Price including 30% of tax, os column A is 130 % of Price
Column B is =A2/130*30
column C is =A2-B2 or =A2/130*100

If you calculate in your exanple 560.00 * 1,3 you will get 728
and not 800


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top