Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Formula reduce amount in a column by 3.21%

Status
Not open for further replies.
JaeBon

JaeBon

Instructor
Jan 31, 2004
26
US
I need to write an Excel formula that will take the amount of money in Column P and reduce that amount by 3.21%. For some reason, I have never quite mastered using percentage. Any adice will be appreciated.

JaeBon
 
Sort by date Sort by votes
=P-0.0321P should reduce the value of P by 3.21%, is this what you mean?
 
Upvote 0 Downvote
=X*(1-0.0321)

Where X equals the Cell (Column P) which you wish to reduce by 3.21 percent.
 
Upvote 0 Downvote
If data in P1 then

=P1-(0.0321*P1)

will do the trick

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
967
bs6600
bs6600
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
757
SkipVought
S
PSchubert
  • Locked
  • Question
Excel: Formula only works with certain numerical values
Replies
12
Views
1K
dhookom
dhookom
remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
460
remeng
remeng
Andrzejek
  • Locked
  • Question
Formula with & and a single quote 2
Replies
4
Views
984
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top