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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top