|
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 |
excel formula
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 - |
excel formula
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 - |
excel formula
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 |
| All times are GMT +1. The time now is 11:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com