QUESTION

I want to see a percent of a total. For instance, I make $925 per day, I want 15% to go to one thing and 10% of the original total to go to another thing, and still another 25% of original total to go to another thing. How do I set up the three columns?

ANSWER

The answer is pretty simple.

If your total is in A1 then in B1 put this formula...

=A1*15%

In C1 put:

=A1*10%

In D1 put:

=A1*25%

Now if you need to apply the formula to the entire column, use the fill handle to copy the formula from cell B1 to the entire B column, as shown in this video:

http://www.youtube.com/watch?v=x1fRZwm1Uqc