RE: Formatting within a formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

hi
another way...
=CONCATENATE(ROUND(A1/2.2,2) &" kg)

regards
FSt1

"WLMPilot" wrote:

I have done this before, but cannot remember how.

I am converting lbs to kg and using CONCATENATE to at the kg on the end of
the formula

Example: A1 = 220 lbs B1: =CONCATENATE(A1/2.2 &"kg)

I need to reduce the answer in B1 to two decimal places. I believe I can do
this within the formula, but not sure.

Thanks for you help.

Les
.

Relevant Pages

  • RE: Is VLOOKUP the right function?
    ... formula is either filtering or creating an extra column where you ... columns and also concatenate the 2 lookup values, ... >> Regards, ... >> Peo Sjoblom ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Concatenate Macro
    ... "Bryan Hessey" wrote: ... What Paul gave you was the equivalant of Concatenate just say ...
    (microsoft.public.excel.misc)
  • Re: Norman Re: Up Arrows / Down Arrows
    ... It is not apparent what you mean by 'concatenate' in this context. ... > Hi Norman ... >> Regards, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Help with CONCATENATE
    ... Regards ... I am trying to CONCATENATE a ... > where G84 is a Sum Statement ... > Thanks in advance, Ray ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Concatenate
    ... Concatenate method appeared to be aproximately 30% slower. ... Regards, ... > Paul Black wrote: ... >> I have a Workbook that Contains About 50 Worksheets. ...
    (microsoft.public.excel.programming)