Re: format of 'if' statement

[Uri David Akavia <uridavid akavia gmail com>]

=IF(D24 >= 125000, D4 * 3650, J30)

You forgot the second comma, and 4D is invalid - it should be D4.

Uri David

On Wed, Apr 14, 2010 at 2:50 PM, ken <gebser mousecar com> wrote:
> I'm trying to assign the result of an 'if' statement to a cell... put
> this in the cell:
>
> =if(d24>=125000,3650*4d,j30)
>
> but it's rejected ("Invalid expression").
>
> So how to do: "IF d24 is greater-than-or-equal-to 125000, THEN multiply
> 4d by 3650, ELSE use the value in cell j30".
>
>
> tnx
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list