Re: format of 'if' statement

[Jean Bréfort <jean brefort normalesup org>]

Le mercredi 14 avril 2010 à 14:50 -0400, ken a écrit :
> 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".

What is 4d? Dou you mean D4?


> tnx
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list