Home |
Search |
Today's Posts |
#1
|
|||
|
|||
entering rates five % higher
how to enter rates which are exactly five percentage points higher than the
rate for each year (excel 2000) |
#2
|
|||
|
|||
=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) |
#3
|
|||
|
|||
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) |
#4
|
|||
|
|||
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) |
#5
|
|||
|
|||
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) |
#6
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to keep users from entering a password on a shared workbook? | Excel Discussion (Misc queries) | |||
How to draw chat by entering equation | Charts and Charting in Excel | |||
How do I import daily currency rates? | Excel Discussion (Misc queries) | |||
How do I set up a spread sheet to calculate pay rates for teacher. | Setting up and Configuration of Excel | |||
Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) |