Function for decreasing salary by 2.5%
- From: "Julie" <Julie@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 8 Sep 2005 09:23:04 -0700
I get salary information for 2005. I want to take that salary back in time
for five years by decreasing the amount by 2.5% per year. When I use the
formula 44,863*(1-0.025) I get 43,742. But when I multiply 43,742 by 2.5% I
get 1093.55. That number added to 43,742 is 44,836 (rounded), not 44,863.
What am I doing wrong? (I submitted this question last night, but I cannot
locate it anywhere and have not been notified of any replies, so I may or may
not have submitted it properly. If duplicated elsewhere please excuse.)
.
- Follow-Ups:
- Re: Function for decreasing salary by 2.5%
- From: CLR
- Re: Function for decreasing salary by 2.5%
- From: Jim Dornbos
- RE: Function for decreasing salary by 2.5%
- From: David Billigmeier
- Re: Function for decreasing salary by 2.5%
- Prev by Date: RE: How can we see two different excel sheets on one screen?
- Next by Date: Re: INDEX and workbooks
- Previous by thread: Count cells with specific values in the cells next to them?
- Next by thread: RE: Function for decreasing salary by 2.5%
- Index(es):
Relevant Pages
|
