0
votes
0answers
50 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
85 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
142 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 ...
17
votes
9answers
46k 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 ...