Can anyone help me with this please?
i have a column of numbers representing gross wages paid. (column A)
in the next column (B) i'd like to show 20% of the figure in A
In the next column (C) i'd like to show A-B
Does any one know how i make a formula that will accomplish this?
MANY THANKS
Hi Ian and welcome to the forum,
Find the attached with what I think you want.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Formula in B2:
=A2*0.2
Formula in C2:
=A2-C2
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
I'm an idiot! Thank you so much
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks