concatenating text elements

[Buckyman]

SketchUp Version: 8
I am trying to create an Item Code thusly:
="6072"&if(PatioCover!BeamHt<=96,"08",if(PatioCover!BeamHt<=120,"10",if(PatioCover!BeamHt<=144,"12","14")))&PatioCover!PostCol
should result in 607208WH
but what I get is 60728WH
Completely illogical esp. since I have everything in quotes and esp. since the last item in the formula resolves to "WH" which would force any spreadsheet (for example) to identify the result as text.

[DareDevil]

SketchUp Version: 8
I am trying to create an Item Code thusly:
="6072"&if(PatioCover!BeamHt<=96,"08",if(PatioCover!BeamHt<=120,"10",if(PatioCover!BeamHt<=144,"12","14")))&PatioCover!PostCol
should result in 607208WH
but what I get is 60728WH
Completely illogical esp. since I have everything in quotes and esp. since the last item in the formula resolves to "WH" which would force any spreadsheet (for example) to identify the result as text.

I never experienced this problem !... but I never use &
I prefer use CONCATENATE function, and your problem is solved, a "0001" is really "0001" not "1"
So your function will be something like
= CONCATENATE ("6072", if(PatioCover!BeamHt<=96,"08", if(PatioCover!BeamHt<=120,"10", if(PatioCover!BeamHt<=144,"12","14"))), PatioCover!PostCol)

[Buckyman]

Well that's a bit embarrassing, I guess I should have checked out the available functions.
Thanks for your help!