format of 'if' statement
- From: ken <gebser mousecar com>
- To: gnumeric-list <gnumeric-list gnome org>
- Subject: format of 'if' statement
- Date: Wed, 14 Apr 2010 14:50:15 -0400
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
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]