0
votes
0answers
5 views

Menu option Insert -> Script… is missing in my Spreadsheet, how do I fix it? [migrated]

I've 2 documents, in 1st one I was able to add 'Script...' (as suggested here) from the Insert menu, but on the 2nd one and all new which I'm creating I don't have this option present. Why this ...
0
votes
0answers
57 views

Google docs SpreadSheet get reuslt from a formula inside a formula

I was trying to obtain the result of a formula that is inside of another formula. | A | B | C | D | E | | Option1 | D2-(D2*10%)| | 10 | Result | | Option2 | ...
0
votes
1answer
93 views

Best way for bidirectional referenced table rows for double-entry booking

I want to move to a Google Spreadsheets setup to handle my private booking. Currently I have four tables: Overview Accounts Income Outcome Except of "Overview" all share following columns: Date ...
0
votes
1answer
149 views

Google Docs / Exel - need to know how to add formula

I'm using Google Docs / Exel and can't work out how or where to add a 'formula'. I have a column "i" which is the number of items. I have another column "j" which is the cost of those items. Column ...
23
votes
10answers
51k views

Formula for updated currency exchange rates in Excel or other spreadsheets?

What kind of spreadsheets support a formula like the following: =exchangeCurrency("USD"; "EUR"; 3000) The result should be 3000 USD exchanged into Euros. Possibly a date could be provided for a ...