Home » Any Answers » Basic Maths

Basic Maths

Posted by girlofwight PM | on Wed, 20/02/2013 - 10:35  2555  78 comments | report

Simple question, I think.

Suppose clients fee was £650 20 years ago, and practice inflation is 4%.

My naive assumption was this was 650*0.04^20 in excel.  But its seems not, as I get 7.146825580544E-26 - oops!

Sure I can do it the long way over 20 rows and 2 columns and arrive at £1,369, but there must be a more elegant way.

 

 

 

Comments
There are 78 comments. Login or register to view them.

=650*(1+4%)^20 

mrme89 | Wed, 20/02/2013 - 10:44

=650*1.04^19

19james88 | Wed, 20/02/2013 - 10:45

^ This

Constantly Confused | Wed, 20/02/2013 - 11:00
Constantly Confused's picture

Polynomial expansion

mikewhit | Wed, 20/02/2013 - 23:22

Err NO

Chris Smail | Wed, 20/02/2013 - 14:56
Chris Smail's picture

Bonkers maths

andrew.hyde | Wed, 20/02/2013 - 15:04

That one has whiskers on it

Chris Smail | Wed, 20/02/2013 - 15:12
Chris Smail's picture

It may have whiskers

paulwakefield1 | Wed, 20/02/2013 - 16:01

Another useful approximation is

paulwakefield1 | Wed, 20/02/2013 - 16:03

Hmm

Constantly Confused | Wed, 20/02/2013 - 16:05
Constantly Confused's picture

Is it...

Constantly Confused | Wed, 20/02/2013 - 16:11
Constantly Confused's picture

It's because

paulwakefield1 | Wed, 20/02/2013 - 16:15

But

Constantly Confused | Wed, 20/02/2013 - 16:32
Constantly Confused's picture

@CC

George Attazder | Wed, 20/02/2013 - 16:38
George Attazder's picture

And I thought you lot were numerate

Chris Smail | Fri, 22/02/2013 - 10:39
Chris Smail's picture

Oh well...

George Attazder | Wed, 20/02/2013 - 17:36
George Attazder's picture

Anything divided by zero is

Triggle | Wed, 20/02/2013 - 17:50

How about

George Attazder | Wed, 20/02/2013 - 17:50
George Attazder's picture

@Triggle

George Attazder | Wed, 20/02/2013 - 17:53
George Attazder's picture

@George

paulwakefield1 | Wed, 20/02/2013 - 17:55

No the result is in fact any

Triggle | Wed, 20/02/2013 - 17:58

You can't prove...

George Attazder | Wed, 20/02/2013 - 18:12
George Attazder's picture

They do

paulwakefield1 | Wed, 20/02/2013 - 18:16

Any number divided by zero is

Triggle | Wed, 20/02/2013 - 18:21

The answer is ...

BKD | Wed, 20/02/2013 - 20:06
BKD's picture

Surely

Pottedbeef | Wed, 20/02/2013 - 20:38
Pottedbeef's picture

What is infinity?

BKD | Wed, 20/02/2013 - 21:02
BKD's picture

Just realised an error...

George Attazder | Wed, 20/02/2013 - 22:20
George Attazder's picture

Let's assume that ...

BKD | Wed, 20/02/2013 - 22:46
BKD's picture

Divide by zero

mikewhit | Wed, 20/02/2013 - 23:25

BKD

Pottedbeef | Thu, 21/02/2013 - 00:08
Pottedbeef's picture

Also

Pottedbeef | Thu, 21/02/2013 - 00:15
Pottedbeef's picture

Proof

BKD | Thu, 21/02/2013 - 08:12
BKD's picture

!

Constantly Confused | Thu, 21/02/2013 - 09:09
Constantly Confused's picture

Linear analysis

neileg | Thu, 21/02/2013 - 09:33

I'm with BKD

kdauda | Thu, 21/02/2013 - 09:47
kdauda's picture

Moving on ...

BKD | Thu, 21/02/2013 - 10:17
BKD's picture

1/0 = Infinity

paras007 | Thu, 21/02/2013 - 10:19

No, no, no BKD (and others)

George Attazder | Thu, 21/02/2013 - 10:33
George Attazder's picture

Or ...

BKD | Thu, 21/02/2013 - 10:27
BKD's picture

No BKD

George Attazder | Thu, 21/02/2013 - 10:31
George Attazder's picture

:)

Constantly Confused | Thu, 21/02/2013 - 10:32
Constantly Confused's picture

∞

Constantly Confused | Thu, 21/02/2013 - 10:39
Constantly Confused's picture

'Real' world

kdauda | Thu, 21/02/2013 - 10:41
kdauda's picture

The square root of -1?

Triggle | Thu, 21/02/2013 - 10:48

No, no ,no, no George

BKD | Thu, 21/02/2013 - 13:48
BKD's picture

Exactly, George

BKD | Thu, 21/02/2013 - 10:57
BKD's picture

It's not my fault...

George Attazder | Thu, 21/02/2013 - 11:03
George Attazder's picture

Gosh

mwngiol | Thu, 21/02/2013 - 11:10
mwngiol's picture

Now we're getting somewhere

BKD | Thu, 21/02/2013 - 11:12
BKD's picture