Rounded decimels

[karkas]

Sorry for an easy one, but I'm having trouble finding/figuring this one out.

I just want the cell to limit the output to no more than 2 decimals

=IF(BA6, M10/2.54&" inches", M10*2.54&" cm")

Where are examples of outputting text with numbers??

Thanks in advance!

 

[xenou]

Hi,

The TEXT() Function would work this way (it involves a little bit of obscure knowledge about format expressions):

=IF(BA6, TEXT(M10/2.54,"#0.00")&" inches", TEXT(M10*2.54,"#0.00")&" cm")

Just be aware (of course) that the result is text, not numeric.

ξ

 

[karkas]

Hi,

The TEXT() Function would work this way (it involves a little bit of obscure knowledge about format expressions):

=IF(BA6, TEXT(M10/2.54,"#0.00")&" inches", TEXT(M10*2.54,"#0.00")&" cm")

Just be aware (of course) that the result is text, not numeric.

ξ

Oh, thanks a lot! And thanks for letting me know it is not a numeric output =D