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

absolute values

ResolvedVersion 2003

Andrew has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Access Advanced course

Absolute values

how do i use absolute values in a formula

RE: absolute values

Hi Andrew

Lets say your formula was =A1/B1
and you wanted the A1 to be absolute but the denominator cell to be variable, you would place dollar symbols as follows =$A$1/B1

Excel tip:

Shortcut keys to move between sheets

Instead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file:

Ctrl + Page Down - Switch to the next worksheet (to the right)

Ctrl + Page Up - Switch to the previous worksheet (to the left)

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.08 secs.