=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 <[email protected]> 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 > [email protected] > http://mail.gnome.org/mailman/listinfo/gnumeric-list > _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
