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

for openoffice use semicolon instead of comma