Re: format of 'if' statement

=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:


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".


gnumeric-list mailing list
gnumeric-list gnome org

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