Basic formula questions

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!
 
D

Dave Peterson

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
 
Top