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

absolute refs

ResolvedVersion 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:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.