Exell
i need to add multiple amount on the same box - Exemple $55.00+$100.00
|
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 |
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