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.