View Single Post
  #8   Report Post  
Posted to free.uk.diy.home,uk.d-i-y
the_constructor[_2_] the_constructor[_2_] is offline
external usenet poster
 
Posts: 274
Default Spreadsheet help


"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