View Single Post
  #3   Report Post  
Gary Brown
 
Posts: n/a
Default

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)