joeu2004:

Most grateful for your insightful approach. Thanks so much.

Pete

At a minimum:

=CONCATENATE("LAB: $",TEXT(CEILING(M59,0.01),"0.00"),
" (",N59," MIN. X .40/MIN.)")

But I think it is preferrable to use ROUNDUP instead of CEILING in this
case.

And there is no need ever to use CONCATENATE. *On the contrary, there is
good reason not to, especially in Excel 2003 and earlier.

So I would write:

="LAB: $" & TEXT(ROUNDUP(M59,2),"0.00") & " (" & N59 & " MIN. X .40/MIN..)"