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.

I figured it out!

=S1!E5*S1!D9

A hint, usually you can do what you need in excel and then more often than not, just copy that formula right over.

Sly once told me he is too cool for Excel.