Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Resolved · Low Priority · Version Standard
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
|
Excel tip:Switch between workbooks ni EXCEL.use Alt-TAB to switch between workbooks. |
We'll call during UK business hours
Server loaded in 0.07 secs.