Rounding a number with letters attached

[tlewis]

I am trying to have the cell output read 127bp. Instead, the cell reads 126.525467428046bp

Here is my formula so far: =((I42-I43)/I43)*10000&"bp"

Cell inputs:
I42= 10.6047
I43= 10.4722

Thanks!

[protonLeah]

Have you looked at the ROUND, CEILING & INT functions?

[tlewis]

Yes, but not sure where to insert them or if it is the correct one to use. Still new at excel programming, obviously.

[protonLeah]

For example:

Please Login or Register  to view this content.

Where the ",0" after ten thousand causes a round up to the nearest unit.

[tlewis]

Thanks for all the help!