View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
 
Posts: 663
Default

Quote:
Originally Posted by Ezoriel View Post
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...