Total - total - % forumula

Hello!

I'm using Excel Mac 2008. I'm very new to excel and need help on the following.

Cell F1: Total
Cell G1: Expenses
Cell H1: Total - Expenses - 30%

So in cell H1, I want to minus (-) G1 from F1 and then minus (-) 30% to give me a total.

How do I do this? I will do this per row as it's a quick break down of jobs I have completed.

Thanks

Sam

That does the trick! Thank you. One question: what if I'd like to change the percentage? Can you explain the *.7 part of the formula?

Thanks

Define in some cell where to write percentage (for example H1)... And then you can change it any time by:

=(G1 - F1) * (1 - H1)

Not that in H1 you must enter 0.3 and format it as %

.7 is 0.7 wich is 70% (100%-30% stated in issue)

That's superb! Thank you!

I presume I have to repeat this equation for each row (job)? The only thing in the equation which will change is the row number i.e. =(G1 - F1) * (1 - H1), =(G2 - F2) * (1 - H1), =(G3 - F3) * (1 - H1).

Thanks

Then you need to lock H1 cell and pull formula down:

=(G1 - F1) * (1 - $H$1)

(note that those $ are crucial)

That's amazing! Thank you so much. You've all been so helpful.

Sam