formulas
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas

Formulas

resolvedResolved · Low Priority · Version Standard

replyReply Tue 19 Feb 2008, 16:07Delegate Maria said...

Maria has attended:
Excel Introduction course

Formulas

i am a bet confused with the dolar singh

For upcoming training course dates see: Pricing & availability

replyReply Thu 21 Feb 2008, 09:49Trainer Mark said...

RE: formulas

Hi Maria how are you

I can give you more info on the dollar signs in Excel, the main reason that you would use the dolloar signs is if you want to use a permanant cell address so that excel will always look to the one place for a certain part of a formula

there are three different ways to use the dollor signs these are listed below

$D$4, $D4, D$4

These work as follows: $D$4 will remember column D and row 4 meaning remember the cell and always look there

The $D4 work by remembering the column D and not remembering row 4

D$4 will then only remember the row 4

Try creating one of these and then copying this down then making changes to the values

Hope this helps

Mark East

 

Please browse our web site to find out more about
excel computer course london and other Microsoft training courses.

Excel tip:

Autosum shortcut key

press ALT + =

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard


Please tell us/web development about this error (copy and paste into an e-mail):
MySQL error: Duplicate entry '5' for key 'PRIMARY'
Line: 76
Actual SQL Query: insert into best_activevisitors (activevisitors_ID, activevisitors_IP, activevisitors_Time, activevisitors_Url) values (5, "38.107.179.244", now(), "/cms/forum.php")
Reported by: function sqlQueryBest()
When viewing (PHP_SELF): /cms/forum.php
Query string from URL: fpost_id=10618