Formatting

L

lsmft

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.
 
B

Bryan Hessey

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?

--
 
L

lsmft

Thanks much but I have already been doing that. What I was wonderin
about was if there were possibly a way to format the cell or row s
that anyone entering data would only need to just enter the number o
items bought into the cell and hit enter, then let the formula o
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 ma
be anywhere from 5 to 25 of these items bought daily. Sometimes th
receipt only shows how many of the items @ $2.12 ea
 
Top