Basic formula questions

  • Thread starter Thread starter kat h
  • Start date Start date
K

kat h

I have a field that contains monthly gross income. From this, I want
to add some formulas beneath it that figures out:

1.) what 8% of the monthly gross income is
2.) what 1.4% of the monthly gross income is
3.) what the remaining monthly gross income is after these deductions

Thanks!
 
One way (with the original monthly income in A1):

Put this in B1:
=8%*a1

Put this in C1:
=1.4%*a1

And put this in D1:
=a1-b1-c1
 
Back
Top