[-- Attachment #1: Type: text/plain, Size: 1134 bytes --] Hi all, I'm testing out whether I can use a table in org as a project status tracker. In col 6, I have the value of the project (e.g. 162.50) and in col 9, the status (e.g. quoted, approved, invoiced, closed, etc.) I would like to see, at a glance, what the value of quoted work is, so I'm currently doing this in col 12 (pasted from formula editor): # Column Formulas $12 = if($9=quoted,$6,0) ( Col 9 in this instance contains "closed" and Col 6 contains 162.50. ) This formula results in the text closed = quoted ? 162.5 : 0 being displayed in col 12. However, in another row where the col 9 does have the text "quoted", I get pretty much the result I'm looking for, e.g. "400." will appear in col 12 where I have 400.00 in col 6. In the instance where the if test proves false, I would like a zero or nothing appearing. The intention is to sum this column in a footer row. I have consulted http://orgmode.org/manual/Formula-syntax-for-Calc.html#Formula-syntax-for-Calcbut it contains a dead link ( http://orgmode.org/calc/Logical-Operations.html#Logical-Operations) - making it harder to RTFM :-) Thanks, -- Steve [-- Attachment #2: Type: text/html, Size: 1663 bytes --]

```
Steve Dowe <stephen.dowe@gmail.com> writes:
> I have consulted
> http://orgmode.org/manual/Formula-syntax-for-Calc.html#Formula-syntax-for-Calc
> but it contains a dead link
> (http://orgmode.org/calc/Logical-Operations.html# Logical-Operations)
> - making it harder to RTFM :-)
>
Until those are fixed, you can consult the org-mode manual on your own
machine using emacs Info: C-h i should get you to the initial page and
you can drill down. But Info offers search as well and it's integrated
with emacs so e.g. if you evaluate this form in emacs, you'll get to
the appropriate section:
(info "(org) Formula syntax for Calc")
You can then follow the links to the calc documentation.
--
Nick
```

Hi Steve On Thu, Jan 9, 2014 at 11:13 AM, Steve Dowe <stephen.dowe@gmail.com> wrote: > $12 = if($9=quoted,$6,0) Follow this path: http://orgmode.org/worg > Tutorials > Tutorials on specific features > Tables, Spreadsheet, Plotting > The following are [...] > most of the automated Emacs Regression Tests (ERT) for Org tables There you will find test-org-table/compare and there if("$1" == "(z)", x, y) which hopefully answers your question. The additional parentheses are Org specific, not Calc specific. Michael

On Thu, 2014-01-09 at 16:36 +0100, Michael Brand wrote: > Follow this path: http://orgmode.org/worg > Tutorials > Tutorials on > specific features > Tables, Spreadsheet, Plotting > The following are > [...] > most of the automated Emacs Regression Tests (ERT) for Org > tables Wow.. it would have taken a long while for me to find this! > There you will find test-org-table/compare and there if("$1" == "(z)", > x, y) which hopefully answers your question. The additional > parentheses are Org specific, not Calc specific. It perfectly answers the question. Thank you. Lots to discover on worg, evidently! -- Steve

```
On Thu, 2014-01-09 at 09:04 -0500, Nick Dokos wrote:
> Until those are fixed, you can consult the org-mode manual on your own
> machine using emacs Info: C-h i should get you to the initial page and
> you can drill down. But Info offers search as well and it's integrated
> with emacs so e.g. if you evaluate this form in emacs, you'll get to
> the appropriate section:
>
> (info "(org) Formula syntax for Calc")
>
> You can then follow the links to the calc documentation.
Thanks for this. It appears I don't have an org info page installed,
which will be my next challenge :)
I must admit, I need to get more into the habit of consulting Emacs' own
help system. Thanks for reminding me of it.
--
Steve
```