Formula For Subtracting Percentages Needed

[Node101]

Hello, I am looking for a very specific formula. I am brand new with Excel 2013 and I got it to help wih my upcoming business. All the information needed to help me will be posted below as this is just an introduction.

I am looking for a formula that can Subtract the Percentage stated in Cell D4 from the total in cell F4.

For example, in the Cell D4 the percentage will be 50% and the number that 50% needs to be subtracted from is located in Cell F4 and displayed in Cell G4. I will need to repeat this for other lines as this is a payroll chart.

Any help is appreciated, thanks.

If more info is needed just ask

[alansidman]

In G4 type =F4-(D4*F4) and then copy down.