Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I thought of that also, it gave me some concern. Had the OP returned and
said simply, no - not homework, I would have given more than just the clue. One thing that pushed me in the Homework direction was the specific wording of the request - reads like out of a text book and had no comment like "my boss has..." or "I know nothing of Excel and..." or "I know that the formula is... but don't know how to put that into Excel"... Never my intent to be rude here, however, I also believe that students should learn or be guided rather than simply be handed the answer. But I've seen questions that appeared to be homework here turn out to be otherwise before, after it was asked "Homework?" " wrote: Marquin wrote: Sales of products in february are expected to grow by 1.56% over January sales, create a formula. Example : January 143 Well, this __is__ m.p.e.NEWUSERS. So a "dumb" question is not necessarily "homework". (By the way, there are no dumb question.) To answer your question: if 143 is in B1, then in B2 you might put: =B1*(1+1.56%) If you want an integer like 143, you can adjust the format (click Format Cells Number Number and select 0 Decimal Places). Or you might change the formula as follows: =round(B1*(1+1.56%), 0) There are pros and cons for each method, and each can be the better answer in different circumstances. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I create a certain type of Excel formula? | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How do I create a 26 'tier' IF formula? | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |