Re: ternary (?:) operator syntax

From: Jean Bréfort <jean brefort normalesup org>
To: gebser mousecar com
Cc: Gnumeric List <gnumeric-list gnome org>
Subject: Re: ternary (?:) operator syntax
Date: Tue, 03 Mar 2009 10:21:15 +0100

Le mardi 03 mars 2009 à 04:11 -0500, ken a écrit :

What's the syntax for the ternary operator?  I tried something as simple as

=(D6>3) ? 30 : 40

and many permutations of that and always get an error: "Invalid expression".

Thanks.



=if(D6>3,30,40)

References:
- ternary (?:) operator syntax
  - From: ken

[Date Prev][Date Next] [Thread Prev][Thread Next] [Thread Index] [Date Index] [Author Index]