Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 380
Default Formula appears as =RC[-3]+RC[-1] Whats this?

ToolsOptionsGeneralR1C1 Reference Style, uncheck it

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Concrete Guy" <Concrete wrote in message
...
I am getting formula formatted as =RC[-3]+RC[-1] when simple Row and

Column
references is what I desire to see. I don't know how to interpret the

formula
as shown when I select that cell. I type in the typical Row/Cell location

but
it gets displayed as above. an anyone help????



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
whats the formula dperalta Excel Worksheet Functions 2 July 17th 08 09:45 PM
Whats wrong with this OR formula? Mark Excel Worksheet Functions 4 October 23rd 06 07:16 PM
whats the big "Page 1" that appears across my spreadsheet? Jennifer Excel Discussion (Misc queries) 1 September 12th 06 05:24 PM
whats wrong with the formula? Gary Excel Worksheet Functions 2 August 3rd 06 11:33 AM
whats wong with this formula? AMDGUY [MCP] Excel Worksheet Functions 1 February 2nd 05 01:28 PM


All times are GMT +1. The time now is 10:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"