Google documents spreadsheet help

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sly
    Let's do some business!
    • Sep 2004
    • 31376
    #1

    Google documents spreadsheet help

    I have a workbook with two spreadsheets, we'll call them S1 and S2.

    S1 has a group of data. S2 is a report of sorts.

    I want S2 to report what would be the following formula on S1: =E5*D9

    How do I make S2 refer to S1? I looked through the help forums and every other comparable question is for more complicated than what I'm looking for.
    Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

    Windows VPS now available
    Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
    Click here for more details.
    Tags: None
    • Sly
      Let's do some business!
      • Sep 2004
      • 31376
      #2
      I figured it out!

      =S1!E5*S1!D9
      Vacares - Web Hosting, Domains, O365, Security & More - Paxum and BTC Accepted

      Windows VPS now available
      Great for TSS, Nifty Stats, remote work, virtual assistants, etc.
      Click here for more details.

        Comment

        • Adraco
          Confirmed User
          • May 2009
          • 3745
          #3
          A hint, usually you can do what you need in excel and then more often than not, just copy that formula right over.
          ----------------------------------------------------------------------------------
          The truth is not affected by the beliefs, or doubts, of the majority.

            Comment

            • amateurbfs
              Confirmed User
              • Jun 2010
              • 1316
              #4
              Sly once told me he is too cool for Excel.

                Comment

                Previous template Next
                Working...