entering rates five % higher
 

how to enter rates which are exactly five percentage points higher than the
rate for each year (excel 2000)

=a1*(1+5%)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"hop 4" <hop wrote in message
...
how to enter rates which are exactly five percentage points higher than
the
rate for each year (excel 2000)

If you mean 5 percent higher than last year...
=A1*1.05
If you mean 5 basis points higher than last year...
=A1+.005

HTH,
Gary Brown

"hop 4" <hop wrote in message
...
how to enter rates which are exactly five percentage points higher than
the
rate for each year (excel 2000)

maybe
for each c in selection
c.value=c*1.05
next c

--
Don Guillett
SalesAid Software

"hop 4" <hop wrote in message
...
how to enter rates which are exactly five percentage points higher than
the
rate for each year (excel 2000)

not to good at this can you explain how to do ,Q.enter the credit card rates
which are exactly five percentage points higher than the rate for each year
of the personal loan...... i am doing a office admin. course. so where do i
put things and what to click on ect; thanks

"Bob Phillips" wrote:

=a1*(1+5%)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"hop 4" <hop wrote in message
...
how to enter rates which are exactly five percentage points higher than
the
rate for each year (excel 2000)

not to good at this can you explain how to do ,Q.enter the credit card rates
which are exactly five percentage points higher than the rate for each year
of the personal loan...... i am doing a office admin. course. so where do i
put things and what to click on ect; thanks

"Bob Phillips" wrote:

=a1*(1+5%)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"hop 4" <hop wrote in message
...
how to enter rates which are exactly five percentage points higher than
the
rate for each year (excel 2000)