Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 10-16-2010, 11:30 AM
Kimberly Kimberly is offline how to read R1C1 formula Windows 7 how to read R1C1 formula Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Your formula is apparently in cell F4. The numbers in square brackets are relative from the current cell. Thus, R[6] means 6 rows below me. By the way, 6 rows above would be R[-6].

If the formula is in row 4, then 6 rows below would be row 10.

And R[27] is 27 rows below row 4, which is row 31.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Documents are Read-only oldbeard Office 0 09-27-2010 07:45 PM
how to read R1C1 formula Read Only problem gg80 Excel 2 08-05-2010 09:09 AM
how to read R1C1 formula Need Help With SUMIF Formula In R1C1 Style Todd Excel 9 02-27-2010 08:30 PM
how to read R1C1 formula Need Help Re: Read-Only mbarbaro Excel 1 07-13-2009 09:16 AM
Read Receipt lfreng Outlook 0 04-11-2006 10:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft