the_constructor wrote:
"Grant" wrote in message
...
the_constructor wrote:

Now the formula that I need is like this:

If (C23670) Then Let C31 = (C23*C27)

MIN(C23*C27,670*C27)


Using OpenOffice spreadsheet program show ERR508 for the above

Fine here using OO 3.0.1 on Ubuntu 9.04.