ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Exell (https://www.excelbanter.com/excel-discussion-misc-queries/251481-exell.html)

ALB

Exell
 
i need to add multiple amount on the same box - Exemple $55.00+$100.00

Max

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


yclhk

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



All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com