From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id wMwUBPiU0WAMhgEAgWs5BA (envelope-from ) for ; Tue, 22 Jun 2021 09:44:56 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 2B9yO/eU0WAlfAAAbx9fmQ (envelope-from ) for ; Tue, 22 Jun 2021 07:44:55 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id ECCFC16D81 for ; Tue, 22 Jun 2021 09:44:54 +0200 (CEST) Received: from localhost ([::1]:43598 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lvb5Z-0005EU-3V for larch@yhetil.org; Tue, 22 Jun 2021 03:44:53 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:60806) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lvb57-0005ED-OB for emacs-orgmode@gnu.org; Tue, 22 Jun 2021 03:44:26 -0400 Received: from mail-db8eur05on2122.outbound.protection.outlook.com ([40.107.20.122]:48545 helo=EUR05-DB8-obe.outbound.protection.outlook.com) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lvb53-0004eF-4o for emacs-orgmode@gnu.org; Tue, 22 Jun 2021 03:44:25 -0400 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=b+LVTO5LsKRVQoxmcYfXjpmfPJltBu8RyeztdGe87cb6nP9UlZohnoVu1DURUQugF7xYThgu0MmDfaINI7ewrSMgXDsH/o5ieoPfsqy0ju/meSC04W4gr0Q7PnsCtcnfflun7KMYAlGdV9VaS0qvQ2WammLjxtmll7tunMWUtUsQHRPOFdH9/ASBgcsVMw+lWb1x1bho1PHtlk8A+ATb3gB+dpVkZlIdydJn1NXEZBnj7IhH490E1xrP7qV3R56/momkdKxylAWNCdh/1fuSOhQia8PHxIZFUj1Xy9sgSigAACbiZcjTpaj/prm8Qvx4PJ946PzmmIH2Vla9Ky8kSg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=XHXhr3I+At2ek91Lm8je3Lh32P/q4JjeOoB3lkHjbK0=; b=DxknkmFkbDcccF2UwCs5qwqq05sObPTtFMiZfFiLYImyjw9f6rWp3ibfsWnuDv2DtE7CLN6Een9O/K2oiaOvMZXSP/7B1ys7Scs6kw2nGmaaY15ufoSC4nUD49k9vN6ASO7SHAlKdIYLek6RkvfBCQv3W+YRkOhD4x/vGKaHuBXtKdl1PK2DzRaue+unTGsNt03fHzkpKb1dBKnAJ43zUOdKmRZvouFzDO+VVRZJ2Ro0UNbQRpn3Vj9nYnUEWGjtlj62GO9YsegAs5P/XaPXHE5eV1qBjE8UIIyrkUgbYD5KZB05E5nOek531E2MgRCb5BpJxermRECjHbls6HKNOA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ucl.ac.uk; dmarc=pass action=none header.from=ucl.ac.uk; dkim=pass header.d=ucl.ac.uk; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucl.ac.uk; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=XHXhr3I+At2ek91Lm8je3Lh32P/q4JjeOoB3lkHjbK0=; b=bSI4P4Uin0H4qxelD4+PPoKDhy9EuDMxr165sRZGQhkl5qkXmIE2Pes+Dzph8akBbvzaRY/uicaqq5Qgsy2oR+EVU8ThDY6OCHhraQTZb60uTgPOY7TBIakH3WqhQYrmMWWO60qjq3TSIzx4/2xeezNEpTHp5fn1ffQSMGtPdM0= Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) by PR3PR01MB8013.eurprd01.prod.exchangelabs.com (2603:10a6:102:174::15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4242.18; Tue, 22 Jun 2021 07:44:17 +0000 Received: from PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::fd73:420d:4389:77b1]) by PAXPR01MB8415.eurprd01.prod.exchangelabs.com ([fe80::fd73:420d:4389:77b1%6]) with mapi id 15.20.4242.023; Tue, 22 Jun 2021 07:44:17 +0000 From: Eric S Fraga To: emacs-orgmode@gnu.org Subject: Re: table: problem with nan and if Organization: On the Interweb somewhere References: <874kdri7h6.fsf@mat.ucm.es> <87eecv41xz.fsf@ucl.ac.uk> <87tulrhwnt.fsf@mat.ucm.es> X-Url: http://www.ucl.ac.uk/~ucecesf/ Mail-Followup-To: Org Mode List Date: Tue, 22 Jun 2021 08:44:15 +0100 In-Reply-To: <87tulrhwnt.fsf@mat.ucm.es> (Uwe Brauer's message of "Mon, 21 Jun 2021 20:58:46 +0200") Message-ID: <871r8u4a40.fsf@ucl.ac.uk> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/28.0.50 (gnu/linux) Content-Type: text/plain X-Originating-IP: [2.29.174.230] X-ClientProxiedBy: LO2P265CA0019.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:62::31) To PAXPR01MB8415.eurprd01.prod.exchangelabs.com (2603:10a6:102:21e::16) MIME-Version: 1.0 X-MS-Exchange-MessageSentRepresentingType: 1 Received: from t3610 (2.29.174.230) by LO2P265CA0019.GBRP265.PROD.OUTLOOK.COM (2603:10a6:600:62::31) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4242.19 via Frontend Transport; Tue, 22 Jun 2021 07:44:16 +0000 X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id: 9f550889-c41d-46e3-3189-08d9355189ae X-MS-TrafficTypeDiagnostic: PR3PR01MB8013: X-Microsoft-Antispam-PRVS: X-MS-Oob-TLC-OOBClassifiers: OLM:4303; X-MS-Exchange-SenderADCheck: 1 X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: 5XSxvTJo+UIDjh8pGF5RwBKyal5fXvYmWeUJnx+wKUMYaZxk32WI1bPo2QJ1w51Ey1vFp0drTPDKAkgC9ef0amQebAhOoFGU0PhgLx9JTiPrYngPMvDGv2ZV/uJz3pA4xALltgGMevkEhqcR+wuKQVCvjHs16NOiyLGwjB023v6w6Ubpdxs8sPRgrm/00w2FOFjtokNJsxRCMyA5bVIfTmHEuYUQytlIV82afBfDuKthZMp0lT9BjshAWB6JnLKmv+gpJqwCct/an/xMsEpGboV6YN3bkoUCmFKSQs28WrzSAWreITvpY/ntDp8Mfg/yvD/KaGkjQzy8quOyt1z8m59T4u0nZaAkvNW5j2k0c8mBk3Llg7GyBfrVFn67/XtcIY01iLHQKqd7blPZWbkbOjxMjLtrV002zTWggm9xGvDkJYg+CrZApctp04lg46Pi2VQFcankACKIBA8E2vy1Q3pwOd3SALyBMTYGf1dI1hX5VsgP6TEb2814szcUuSYzM+vd6XSG2mummmuNfgEMCoT9ZBBZGSmFHG3oyr3zx13aNr20Kz7pBLeXy07Kg9MHQD839Br+qtDaxwSDudFRfqoSL+GRlkriE28i3NnGIhOs/9ABKCgSw/IeibdxU/by+VYaXPhKLKn74NGYPE4wDcrQNlPltdmG1edHj1gDeD4Zh6mEvqkOvct8spTrpU6TCAhQIQz1phh9BdaWHYI5p//73N5vkjs6qHa4lAfw3Px0vLquVDDbM01amg8XhP1luy+G4zuwCDJsv1UJnQs3zg== X-Forefront-Antispam-Report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:PAXPR01MB8415.eurprd01.prod.exchangelabs.com; PTR:; CAT:NONE; SFS:(4636009)(396003)(136003)(346002)(366004)(39860400002)(376002)(558084003)(36756003)(2906002)(966005)(38350700002)(478600001)(6496006)(86362001)(5660300002)(8936002)(6916009)(6486002)(36916002)(52116002)(786003)(66476007)(66556008)(26005)(316002)(956004)(2616005)(16526019)(38100700002)(186003)(66946007)(8676002); DIR:OUT; SFP:1102; X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1 X-MS-Exchange-AntiSpam-MessageData-0: =?us-ascii?Q?irQG4drPDARvbrdZ2BAwdHEqKVyH3CLxPj+o0rKiLBNz6W5iy9SvytuvWxa6?= =?us-ascii?Q?vi6YbFLTQw2+K4l88BmKomiJ6O+2VhzqJMoAdTPzZLYjwJx0Jnv9JQzDConj?= =?us-ascii?Q?uXfqDlpD/WlTj8YzgMZBSWhI3dkDysgIUMBS72j1IYS9gKznpNCq8Jqt/eee?= =?us-ascii?Q?Rw3tUiWdZ4Ogsnzg1CXp0GJVWJHdIiRJ6ynT7kZAPkTr1Tgvui9mgLogsqa9?= =?us-ascii?Q?fEBURBhl1lTNf1xfun3M44qcbSzKR9Dl1K6r0k7ZOWLiJZgtaQVk2zVisI7o?= =?us-ascii?Q?bR7A87oa3Q2uu1WAfnec4jPr844kJADoRIICWgvlJn2f2b685+k0d3KXUHU3?= =?us-ascii?Q?ULwRSbBQAzQXCAYYUvCKBbsTTWSPfS/XwhSeYZxr86C5n+dcmDpoGO4fl2r4?= =?us-ascii?Q?cwva9CsYGcWiDvtoVj7R4H6PsjsP/OcW18zIOYFZ9uEL7h6w1+SfubPcpDqT?= =?us-ascii?Q?LeaydTGcqMysSbqHw5C8uyeKyOFgqNcPsuYFh4mVQvTKBxQyiAGuhLd4xuDj?= =?us-ascii?Q?02Vdq09RcbcZZDu+Yg1z+4oETZngSWaurD7Elm0gnYMKe3dttKho6NiZS7Vh?= =?us-ascii?Q?vOby/DMlDKzSQdohBl7fMSYIxE74usKKLyC4mJDvYn+z6lFC6bTITysiOirN?= =?us-ascii?Q?EXq/bDwNQ8Onp+cerBGQk72umjuKQWqfMxEOfT6la2zqPLwEoSus7Rv3g1cu?= =?us-ascii?Q?Rl2EAyMmMr91/m0vQbUuol1q8VNDZRRQf8C9+fCvg7gCGjS61VdVeyrLCsWx?= =?us-ascii?Q?ruTNiOXUACFq0grSNzlPA9FsXYgo1GuRIEDbDG/QAT0nCjTlL46peHOu492N?= =?us-ascii?Q?i9fSWOxEMHOw+bSIb4un4UJRG4eFp/BsA5mzJI9GWOYp48TTst6eTEDauJ8E?= =?us-ascii?Q?+aSbYu/z4pt/1kJpe76PMowVjqJkFXxQoZNIbXW/Nwdd5+yYdF4/ofArF81P?= =?us-ascii?Q?ouymlOOliOFUrIzl+GPLfHGZ22KLpFkfDDt2Zi9VUlntI3bdxJ4NyKoYjAUJ?= =?us-ascii?Q?BP7ZLXM6yRKpvIHOL6ljGPTgy6xf5ZcsRXWkETxXzp/hZ6elPKwZsAotkyG9?= =?us-ascii?Q?qKcaDokxha1LSZbaNW07Ul57AuGOLgfPQTwbVY79mTr0OA+ejQbtGy1w0/Zr?= =?us-ascii?Q?mcu8DH/DEJVgi1BCLXhZYUZeqJFy0tdi0T/NSGVjD1JsZeJlhgrOawKktHw0?= =?us-ascii?Q?rwk0g7JTqUPexVvqHIjjrxom+sIWwp4RgfnAubOUdJbn4qaxFJlri40fBNks?= =?us-ascii?Q?ODgJorEwhfr/tDrygs4e/4UjlMJ7BoCTEkYnjDCvnwPZKeaaYmViYqbv3eyz?= =?us-ascii?Q?V7+M5peLVRNU1pUihqMm2Lk+?= X-OriginatorOrg: ucl.ac.uk X-MS-Exchange-CrossTenant-Network-Message-Id: 9f550889-c41d-46e3-3189-08d9355189ae X-MS-Exchange-CrossTenant-AuthSource: PAXPR01MB8415.eurprd01.prod.exchangelabs.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-OriginalArrivalTime: 22 Jun 2021 07:44:17.1707 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-CrossTenant-Id: 1faf88fe-a998-4c5b-93c9-210a11d9a5c2 X-MS-Exchange-CrossTenant-MailboxType: HOSTED X-MS-Exchange-CrossTenant-UserPrincipalName: PI7w3vLFmXOyI5Dx9+Xrxtd57k6owFgGqeBUMsODCeepgHw6eHq4GKqx9u/KBx2NefNh12yF62/J31mA9s2u+Q== X-MS-Exchange-Transport-CrossTenantHeadersStamped: PR3PR01MB8013 Received-SPF: pass client-ip=40.107.20.122; envelope-from=e.fraga@ucl.ac.uk; helo=EUR05-DB8-obe.outbound.protection.outlook.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1624347895; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=XHXhr3I+At2ek91Lm8je3Lh32P/q4JjeOoB3lkHjbK0=; b=M9fhkmtDBibBHRvqEsDb8757c7815v82H5VrW/GHPW3D+O0jXYKfkFchUDi5mHkS5MZK8W yaPhaJm5eY1R/j8Voki/R4hVZsDSxA5nUghwggHI5AtzLhjQa33lXpLiaFKu5Fe9C5kQoG LTH3Rur1Q66/EcrBVR9T2W17xhrv15Pn0sfnI28cFMYB696GReHGTIPuRVna885bKGNPme 5YCh3w5at8o9WCx8gN9IQXPnaMEZCvxAqLthKjL8BTGPhjrKUg+Bo3b9DXdy8jEIrXT8re IFUwfceGThuypJeCAJm+3Vj4DupnbtsvHJQU2YaqCQduDcP50pNVS5j0t0NYnw== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1624347895; a=rsa-sha256; cv=pass; b=NmHUPMKYUL+D4fmDPrECEgSS0Fs1NQF8KG3Kov5T7ZQOlr2DYSsDtGwZ8VjDqVUEyZEnE4 xwIQ7MbMK6UvkJHk7RRUgWpCgV2297y5YwqQ7PVRDRU0lAsqd3kSgV39i+2xY1BTGuD+Wr fY5LertioddcjZlMZzecUtKqFzZgOb9Y0uNY6/UEM/latujosw7vddsUkGIoJp5zzcDUYC jFedx31ry/5pOaQ4Il73JFPDbJl1gaUniimsJQ0h9r0botu1vC1MUlYHTkxpxTUz/1HE+w gzst8MFeivFM6jcCUxm/mLhmjBynFKBfPxifAoPznflwcWSEAjaRo7y19RdgYQ== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=bSI4P4Ui; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -4.12 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=ucl.ac.uk header.s=selector1 header.b=bSI4P4Ui; arc=pass ("microsoft.com:s=arcselector9901:i=1"); dmarc=pass (policy=none) header.from=ucl.ac.uk; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: ECCFC16D81 X-Spam-Score: -4.12 X-Migadu-Scanner: scn0.migadu.com X-TUID: OHPPpKgHzBeF Uwe, what if you change the E in each equation with N? You'll get 0 entries when the calculations involve all empty cells which might not be what you want, of course. -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-566-gf0198e : Latest paper written in org: https://arxiv.org/abs/2106.05096