format of 'if' statement



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]