excel formula

[bronxbabe]

hello,
i'm trying to create a formula using 88 and .03%. for example, in cell D is
the number "88". in the next cell, i need the sum of 88 plus 0.03%. how
would this formula be done? i've tried =SUM(D22+.03), but that gives me an
error message. the result in the next cell should be 90.64 (88 plus 2.64).
thanks in advance.

 

[Gary''s Student]

=(1+.03)*D22

 

[bronxbabe]

THANK YOU VERY MUCH -- IT WORKED!!!

But, what does the "1" refer to?

THANK AGAIN!!!

 

[Tyro]

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

 

[Matt Richardson]

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

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

 

[Meenie]

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

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

 

[Meenie]

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.

 

[bronxbabe]

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

 

[bronxbabe]

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]

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

 

[bronxbabe]

nice jab, Matt

11:50EST

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

 

[David Biddulph]

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.

 

[Meenie]

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)

 

[Meenie]

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

 

[Meenie]

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

 

[Pete_UK]

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

 

[Meenie]

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

 

[Meenie]

hehe, thanks David... you were too fast, I posted a correction - we must
have been typing at the same time! 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