3

For a Microsoft Formula like this:

=IF(Data!H5=3,0,IF(Data!H5<=Data!H19,3,IF(Data!H5<=Data!H20,2,IF(Data!H5<=Data!H21,1,0))))

Is it possible to mass convert all the relative cell references to absolute references?

The desired formula would be:

=IF(Data!$H$5=3,0,IF(Data!$H$5<=Data!$H$19,3,IF(Data!$H$5<=Data!$H$20,2,IF(Data!$H$5<=Data!$H$21,1,0))))
Improve this question

1 Answer 1

Reset to default
4

Press F4 repeatedly while editing the formula to cycle among reference styles. You may need to select the whole formula to affect all the references in it.

In Excel:Mac 2011 (and possibly other versions for Mac), Press CommandT instead.

Improve this answer
3
  • Thanks. Selecting the whole formula is required before cycling through the F4 options.
    – John M
    Feb 23, 2011 at 17:26
  • Doesn't work on Mac
    – StatsSorceress
    Aug 26, 2017 at 22:29
  • @StatsSorceress: Added Mac keystroke to my answer
    – Dennis Williamson
    Aug 29, 2017 at 16:05

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .