Tom Cloyd wrote:
> * changing the original formulat to =IF($E10="x",&"K4",0) or
> =IF($E10="x",&K4,0) - where K4 is the cell with the calculated text string.
> Either of these result in an error 510.
I notice the part &"K4"
I think you may have confused your syntax here. In Calc formulas, the
ampersand (&) symbol is actually the concatenation operator. I
suspect you're coming from a C/C++ environment.
> Here's the calculation formula for the string:
> =CONCATENATE("'",K2,K1,"-",K3,"',N$4")
Another way of doing this would be:
= "'" & K2 & K1 & "-" & K3 & "',N$4"
It should do the same as your concatenate example, just another way of
writing it
Regards
Stephan
--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
