Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |