absolute refs

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Absolute Refs

Absolute Refs

resolvedResolved · Low Priority · Version 2003

Adil has attended:
Excel Introduction course

Absolute Refs

i'm not sure how to practically apply this function..
But i'm taking the intermediate course,next week

RE: Absolute Refs

Hi Adil

Thanks for the post - sorry my reply is late

All you need to remember is how to put in $ signs and why

How is by pressing the F4 function key until you place the $ signs where you need them

Why - is because you want to always calculate with a cell or part of a spreadsheet

EG: $d$4 = cell, d$4 = row, $d4 = Colunm

Hope this helps

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Mon 8 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips


Server loaded in 0.08 secs.