Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exell
i need to add multiple amount on the same box - Exemple $55.00+$100.00
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exell
Better not to. Use separate cells for each amount, eg put the multiple
amounts in A1, A2, A3, etc. Then put this in B1: =SUM(A:A) to compute the total of all the amounts. Any good? hit the YES below. -- Max Singapore --- "ALB" wrote: i need to add multiple amount on the same box - Exemple $55.00+$100.00 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exell
In the cell, type =55+100 then format the cell to $ with two decimal point.
"=" tell the Excel to calculate. However, I agree with Max's reply, it is the wise way to use the formula to calculate in Excel. "ALB" wrote: i need to add multiple amount on the same box - Exemple $55.00+$100.00 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exell Cell Locking | Excel Discussion (Misc queries) | |||
What is the formula for adding up *values! in a columm in exell | Charts and Charting in Excel | |||
How do I get my header in Exell to follow me down a spread sheet | New Users to Excel | |||
Exell bug | Excel Discussion (Misc queries) | |||
"Print Report" in Exell 2003 | Excel Discussion (Misc queries) |