Skip to main content

Home/ Useful Technologies/ Group items tagged formula

Rss Feed Group items tagged

George Bradford

Excel formula to reference 'CELL TO THE LEFT' - Stack Overflow - 0 views

  •  
    " 1 down vote Instead of writing the very long: =OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1) You can simply write: =OFFSET(*Name of your Cell*,0,-1) Thus for example you can write into Cell B2: =OFFSET(B2,0,-1) to reference to cell B1"
George Bradford

How to add " (quote) in Excel formula - Windows - 0 views

  •  
    "Example = "I want " & ""THIS"" & " to be quoted" The result should be: I want "THIS" to be quoted" "Another way is to put """" in a cell and reference it Solution Example: ="""" in cell A1 = "I want " & A1 & "THIS" & A1 & " to be quoted""
1 - 2 of 2
Showing 20 items per page