#1   Report Post  
Posted to microsoft.public.excel.misc
ALB ALB is offline
external usenet poster
 
Posts: 2
Default Exell

i need to add multiple amount on the same box - Exemple $55.00+$100.00
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 48
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exell Cell Locking Jonathan Excel Discussion (Misc queries) 1 November 6th 06 04:51 PM
What is the formula for adding up *values! in a columm in exell Larry Charts and Charting in Excel 1 October 20th 06 08:30 AM
How do I get my header in Exell to follow me down a spread sheet Kawasaki New Users to Excel 3 May 29th 06 12:50 AM
Exell bug Luis Cabrera Excel Discussion (Misc queries) 1 March 9th 06 06:11 PM
"Print Report" in Exell 2003 gogaiobashvili Excel Discussion (Misc queries) 1 August 7th 05 05:36 PM


All times are GMT +1. The time now is 04:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"