Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
Is there a way to program or format one cell/row of a worksheet so that I can enter a number of items bought and the cell will automatically show the gross expense in that same cell? Some of the items I purchase are billed out as "x" amount of items at "xx" price. Normally I work the math and enter the extended amount. But, just curious if it is possible to simply enter the amount of items bought and let the computer do the math and show the extended amount, in that same cell as number of items were entered. -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=538815 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
You can enter =99*12.50 or =99*A3 where A3 contains your price and the formula bar will show the entry, the cell will show the result. Is that what you meant? -- lsmft Wrote: Is there a way to program or format one cell/row of a worksheet so that I can enter a number of items bought and the cell will automatically show the gross expense in that same cell? Some of the items I purchase are billed out as "x" amount of items at "xx" price. Normally I work the math and enter the extended amount. But, just curious if it is possible to simply enter the amount of items bought and let the computer do the math and show the extended amount, in that same cell as number of items were entered. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=538815 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting
Thanks much but I have already been doing that. What I was wondering about was if there were possibly a way to format the cell or row so that anyone entering data would only need to just enter the number of items bought into the cell and hit enter, then let the formula or programming of the cell extend the amount paid out in that same cell. In this particular case the cost of this item is $2.12 each. There may be anywhere from 5 to 25 of these items bought daily. Sometimes the receipt only shows how many of the items @ $2.12 ea. -- lsmft ------------------------------------------------------------------------ lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678 View this thread: http://www.excelforum.com/showthread...hreadid=538815 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |