[OOo Calc] Spreadsheet: IF / THEN ?

Closed
ddalley Posts 6 Registration date Sunday January 31, 2010 Status Member Last seen March 23, 2010 - Mar 23, 2010 at 03:08 AM
 abcdefg - Nov 15, 2011 at 02:54 PM
<Edit> Hello</Edit>

I would like to make a comparison calculation and tried to use an IF(), but I keep getting an error. I use Open Office Calc, here, but that shouldn't matter. What does matter is that I don't know what I am doing with a formula.

I want to compare the elapsed time value in one cell with a new value and, if the new value is lower, to save the new value in the first cell. If the value is equal or > the old value, then I do nothing and move to the next cell.

I can seed the old data column with higher numbers, but it doesn't seem to make a difference,

I was able to use this time format (00:00.000) to do another calculation, so that should be OK.

=IF(C7<E7,C7,E7)

What is wrong? Am I going about this the right way?

I'd also like to find a list of OO.o Calc error numbers and definitions.

<Edit> Thanks in advance</Edit>

1 response

ddalley Posts 6 Registration date Sunday January 31, 2010 Status Member Last seen March 23, 2010
Mar 23, 2010 at 05:53 PM
Anyone with spreadsheet experience?
0
Try semicolon =IF(C7<E7;C7;E7) in place of comma for then and else.
0