It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

On Feb 13, 5:39 am, "Tyro" wrote:
It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro

"bronxbabe" wrote in message

...

THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

Tyro, I don't see the need to patronise others because they don't
understand something. We're supposed to be here to help, not to
criticise people because they might not be as clever.

Sorry to have a go but I don't think its fair.

Regards,
Matt Richardson
http://teachr.blogspot.com

nice jab, Matt ;)

11:50EST

"Matt Richardson" wrote:

On Feb 13, 5:39 am, "Tyro" wrote:
It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro

"bronxbabe" wrote in message

...

THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

Tyro, I don't see the need to patronise others because they don't
understand something. We're supposed to be here to help, not to
criticise people because they might not be as clever.

Sorry to have a go but I don't think its fair.

Regards,
Matt Richardson
http://teachr.blogspot.com

Wow, that's the first flame I ever saw here! :)

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

that's ok. i DID go to school and i'm smart enough to ignore a..holes like
tyro.

but, ... i figured it out. the "1" in the formula =(1+0.3)*D22 indicates
the first cell to the left.

can u explain that, TYRO???

HA!
11:25EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

i just created that bs because it sounds good, but the reply to Tyro stands!

Meenie's formula is much easier for a novice to understand!

11:29EST

"bronxbabe" wrote:

that's ok. i DID go to school and i'm smart enough to ignore a..holes like
tyro.

but, ... i figured it out. the "1" in the formula =(1+0.3)*D22 indicates
the first cell to the left.

can u explain that, TYRO???

HA!
11:25EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

I'm delighted that your novice understands where the value in A2 in Meenie's
formula comes from, and how that value relates to the value in D22. :-)
--
David Biddulph

"bronxbabe" wrote in message
...
i just created that bs because it sounds good, but the reply to Tyro
stands!

Meenie's formula is much easier for a novice to understand!

11:29EST

"bronxbabe" wrote:

that's ok. i DID go to school and i'm smart enough to ignore a..holes
like
tyro.

but, ... i figured it out. the "1" in the formula =(1+0.3)*D22 indicates
the first cell to the left.

can u explain that, TYRO???

HA!
11:25EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done
=(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems
to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of
something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus
3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

hehe, thanks David... you were too fast, I posted a correction - we must
have been typing at the same time! :D I did it in my excel and used a2
instead of d22
I think it was a nice example of "seeing what one knew should be there" lol

"David Biddulph" wrote:

I'm delighted that your novice understands where the value in A2 in Meenie's
formula comes from, and how that value relates to the value in D22. :-)
--
David Biddulph

"bronxbabe" wrote in message
...
i just created that bs because it sounds good, but the reply to Tyro
stands!

Meenie's formula is much easier for a novice to understand!

11:29EST

"bronxbabe" wrote:

that's ok. i DID go to school and i'm smart enough to ignore a..holes
like
tyro.

but, ... i figured it out. the "1" in the formula =(1+0.3)*D22 indicates
the first cell to the left.

can u explain that, TYRO???

HA!
11:25EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done
=(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems
to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of
something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus
3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

Oops my formula should have read: =(d22*.03)+d22
NOT =(d22*.03)+A2
I worked it in my excel and used A2 instead of D22 LOL

Oh well, if it makes him feel better about himself to put others down, who
are we to take away his security blanket? :)

"bronxbabe" wrote:

that's ok. i DID go to school and i'm smart enough to ignore a..holes like
tyro.

but, ... i figured it out. the "1" in the formula =(1+0.3)*D22 indicates
the first cell to the left.

can u explain that, TYRO???

HA!
11:25EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

actually Meenie i don't think your formula would work. i'm calculating state
tollroad revenues and each cell (year) increases 3% more than the previous --
"D" being the first cell (year).

thanks,
11:43EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

So the .03% is always of the previous cell? ie: the first cell was 88, the
next was .03% of 88 added to 88 - =(d22*.03)+d22? So if you use the fill
function to drag the formula over to the next cell, the formula will increase
with you ie: drag d23 to d24 and the formula will change to =(d23+.03)+d23
and so on.
I did it and it appears to work (I started in a1) :
88 90.64 93.36 96.16 99.04 102.02 105.08
It seems to work in my graph (and on my calculator too) :)



"bronxbabe" wrote:

actually Meenie i don't think your formula would work. i'm calculating state
tollroad revenues and each cell (year) increases 3% more than the previous --
"D" being the first cell (year).

thanks,
11:43EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro


"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768

Meenie,

just a small point - if you copy across then it is the letter
reference that will change, so

=(D22*0.03)+D22 (another typing mistake)

will become:

=(E22*0.03)+E22
and
=(F22*0.03)+F22

and so on.

Pete

On Feb 13, 6:31*pm, Meenie wrote:
So the .03% is always *of the previous cell? ie: the first cell was 88, the
next was .03% of 88 added to 88 - =(d22*.03)+d22? So if you use the fill
function to drag the formula over to the next cell, the formula will increase
with you ie: drag d23 to d24 and the formula will change to =(d23+.03)+d23
and so on. *
I did it and it appears to work (I started in a1) :
88 * * *90.64 * 93.36 * 96.16 * 99.04 * 102.02 *105.08
It seems to work in my graph (and on my calculator too) :)



"bronxbabe" wrote:
actually Meenie i don't think your formula would work. *i'm calculating state
tollroad revenues and each cell (year) increases 3% more than the previous --
"D" being the first cell (year).

thanks,
11:43EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. *If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro

"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768- Hide quoted text -

- Show quoted text -

Thanks Pete, my fingers are out of sync with my eyes today :)
Anyway, drag it across and it appears to work. :)

"Pete_UK" wrote:

Meenie,

just a small point - if you copy across then it is the letter
reference that will change, so

=(D22*0.03)+D22 (another typing mistake)

will become:

=(E22*0.03)+E22
and
=(F22*0.03)+F22

and so on.

Pete

On Feb 13, 6:31 pm, Meenie wrote:
So the .03% is always of the previous cell? ie: the first cell was 88, the
next was .03% of 88 added to 88 - =(d22*.03)+d22? So if you use the fill
function to drag the formula over to the next cell, the formula will increase
with you ie: drag d23 to d24 and the formula will change to =(d23+.03)+d23
and so on.
I did it and it appears to work (I started in a1) :
88 90.64 93.36 96.16 99.04 102.02 105.08
It seems to work in my graph (and on my calculator too) :)



"bronxbabe" wrote:
actually Meenie i don't think your formula would work. i'm calculating state
tollroad revenues and each cell (year) increases 3% more than the previous --
"D" being the first cell (year).

thanks,
11:43EST

"Meenie" wrote:

Actually, I don't get using the 1 either. I would have done =(d22*.03)+a2
It comes out the same (I do see the other works also but it seems a bit
'round the elbow). You get the same answer with either, but one seems to use
logic that is more easily followed.

"Tyro" wrote:

It's called basic arithmetic. If I want to have 3% more of something, I
need to have the whole somehthing, 1, and the 3% more, thus 1 plus 3%, that
is to say 1.03.

Did you go to school?

Tyro

"bronxbabe" wrote in message
...
THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

"Gary''s Student" wrote:

=(1+.03)*D22
--
Gary''s Student - gsnu200768- Hide quoted text -

- Show quoted text -