formatting numbers within a "CONCATENATE" formula

Posted by Daniel P. on May 17, 2000 8:59 AM

I have the following formula figuring both Pieces (PCS) and Linear Feet (LF).

"=IF(ISBLANK(A15)," ",(IF(J15=0,"S/U",(CONCATENATE(J15-L15," PC(s) / ",((J15*I15)-(L15*K15))/12," LF")))))"

My problem is that the linear feet (LF) results... "((J15*I15)-(L15*K15))/12"... are not formatted.

I want it formatted to display to 3 decimal places.
Any suggestions?

Thanks for the help,
Daniel P.

Posted by Ivan Moala on May 17, 2000 12:52 PM

Hi Daniel try rounding to 3 Dec Places the LF part
of your formula eg.
=IF(ISBLANK(A18)," ",(IF(J18=0,"S/U",(CONCATENATE(J18-L18," PC(s) / ",ROUND((((J18*I18)-(L18*K18))/12),3)," LF")))))

Ivan

Posted by Daniel P. on May 17, 2000 2:31 PM

Thanks, I knew there had to be a way. I had never used ROUND in a formula before.

Thanks again for all the help!
Daniel P.