Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1190468%22%20slang%3D%22en-US%22%3EFormula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1190468%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20apologies%20if%20this%20is%20very%20basic%20but%20I%20have%20noticed%20that%20all%20my%20basic%20excel%20formulas%20eg%20SUM%20and%20%26nbsp%3Bautosum%20have%20changed%20and%20instead%20of%20seeing%20the%20row%20and%20cell%20references%20eg%20SUM(A1%3AG7)%20the%20formulas%20are%20now%20shown%20in%20this%20type%20of%20format%20%26nbsp%3BSUM(R%5B-17%5DC%3AR%5B-1%5DC).%20As%20I%20do%20not%20understand%20the%20logic%20I%20am%20worried%20the%20formula%20may%20be%20incorrect.%20%26nbsp%3BI%20am%20sure%20this%20is%20a%20setting%20which%20has%20changed%20but%20I%20have%20not%20been%20able%20to%20find%20it.%20Can%20anyone%20please%20tell%20me%20what%20I%20need%20to%20change%20so%20that%20I%20see%20the%20simple%20row%20and%20cell%20numbers%20%3F%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1190468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1190486%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1190486%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F566553%22%20target%3D%22_blank%22%3E%40haloes%3C%2FA%3E%26nbsp%3BGo%20to%20Excel%2C%20Preferences...%2C%20General.%20Uncheck%20%22Use%20R1C1%20references%20style%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202020-02-24%20at%2012.34.38.png%22%20style%3D%22width%3A%20392px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F172919i1DC42E24CFCA35C9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screenshot%202020-02-24%20at%2012.34.38.png%22%20alt%3D%22Screenshot%202020-02-24%20at%2012.34.38.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1190494%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1190494%22%20slang%3D%22en-US%22%3E%40Riny%20-%20Many%20thanks%2C%20so%20simple%20if%20you%20know%20where%20to%20look.%20thanks%20for%20the%20prompt%20reply%20too%20!%3C%2FLINGO-BODY%3E
New Contributor

Hi, apologies if this is very basic but I have noticed that all my basic excel formulas eg SUM and  autosum have changed and instead of seeing the row and cell references eg SUM(A1:G7) the formulas are now shown in this type of format  SUM(R[-17]C:R[-1]C). As I do not understand the logic I am worried the formula may be incorrect.  I am sure this is a setting which has changed but I have not been able to find it. Can anyone please tell me what I need to change so that I see the simple row and cell numbers ?

Many thanks

 

2 Replies

@haloes Go to Excel, Preferences..., General. Uncheck "Use R1C1 references style"

Screenshot 2020-02-24 at 12.34.38.png

@Riny - Many thanks, so simple if you know where to look. thanks for the prompt reply too !