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

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

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