 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2008excel formula
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. =(1+.03)*D22  SignatureGary''s Student - gsnu200768 THANK YOU VERY MUCH -- IT WORKED!!! But, what does the "1" refer to? THANK AGAIN!!! > =(1+.03)*D22 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 > THANK YOU VERY MUCH -- IT WORKED!!! > [quoted text clipped - 3 lines] > >> =(1+.03)*D22 > 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 [quoted text clipped - 13 lines] > >> -- > >> 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 > > 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 [quoted text clipped - 23 lines] > Matt Richardson > http://teachr.blogspot.com 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 [quoted text clipped - 11 lines] > > > >> =(1+.03)*D22 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. > 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 [quoted text clipped - 11 lines] > > > >> =(1+.03)*D22 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 > 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 [quoted text clipped - 16 lines] > > > > > >> =(1+.03)*D22 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 > that's ok. i DID go to school and i'm smart enough to ignore a..holes like > tyro. [quoted text clipped - 27 lines] > > > > > > > >> =(1+.03)*D22 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. :-) SignatureDavid Biddulph >i just created that bs because it sounds good, but the reply to Tyro >stands! [quoted text clipped - 39 lines] >> > > > >> > > >> =(1+.03)*D22 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 > 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. :-) [quoted text clipped - 41 lines] > >> > > > > >> > > >> =(1+.03)*D22 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? :) > that's ok. i DID go to school and i'm smart enough to ignore a..holes like > tyro. [quoted text clipped - 27 lines] > > > > > > > >> =(1+.03)*D22 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 > 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 [quoted text clipped - 16 lines] > > > > > >> =(1+.03)*D22 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) :) > 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 -- [quoted text clipped - 23 lines] > > > > > > > >> =(1+.03)*D22 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 > 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 [quoted text clipped - 36 lines] > > - Show quoted text - Thanks Pete, my fingers are out of sync with my eyes today :) Anyway, drag it across and it appears to work. :) > Meenie, > [quoted text clipped - 53 lines] > > > > - Show quoted text - |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.