1
   

creating a formula

 
 
Reply Sun 29 Jun, 2008 12:42 am
good evening everybody, I am going to be tested on Monday for a new job as an Account Clerk II and this involves using formulas on excel. You must think I am very dumb, but I have not used formulas in years and forgot how they work. On the test, I have to enter currency on cells on Row A and put the formula on Row B to add the cells on Row A. PLEASE HELP ME!!!
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Discussion • Score: 1 • Views: 303 • Replies: 1
No top replies

 
dadpad
 
  1  
Reply Sun 29 Jun, 2008 07:44 am
1. select the answer cell enter the following
= sum (A1:A5) where A1:A5 are the cells required to be added
format the answer cell to currency (right click> format cell)

2. use the sigma function.
0 Replies
 
 

Related Topics

Clone of Micosoft Office - Question by Advocate
Do You Turn Off Your Computer at Night? - Discussion by Phoenix32890
The "Death" of the Computer Mouse - Discussion by Phoenix32890
Windows 10... - Discussion by Region Philbis
Surface Pro 3: What do you think? - Question by neologist
Windows 8 tips thread - Discussion by Wilso
GOOGLE CHROME - Question by Setanta
.Net and Firefox... - Discussion by gungasnake
Hacking a computer and remote access - Discussion by trying2learn
 
  1. Forums
  2. » creating a formula
Copyright © 2026 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.05 seconds on 01/01/2026 at 06:15:09