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.

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...

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2