Skip to main content
Web Applications

Return to Answer

added 32 characters in body
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78
  • with &=B2-80&"kg or "&(B2-80)*2.2&" lbs": 
    =B2-80&"kg or "&(B2-80)*2.2&" lbs"
     5
  • with JOIN=JOIN("kg or "; B2-80; (B2-80)*2.2&" lbs"): 
    =JOIN("kg or "; B2-80; (B2-80)*2.2&" lbs")
     5
  • =CONCAT(B2-80&"kg or "; (B2-80)*2.2&" lbs")
  • =CONCATENATE(B2-80; "kg or "; (B2-80)*2.2; " lbs")

5

5

  • with &: 
    =B2-80&"kg or "&(B2-80)*2.2&" lbs"
     5
  • with JOIN(): 
    =JOIN("kg or "; B2-80; (B2-80)*2.2&" lbs")
     5
  • =B2-80&"kg or "&(B2-80)*2.2&" lbs"
  • =JOIN("kg or "; B2-80; (B2-80)*2.2&" lbs")
  • =CONCAT(B2-80&"kg or "; (B2-80)*2.2&" lbs")
  • =CONCATENATE(B2-80; "kg or "; (B2-80)*2.2; " lbs")

5

5

added 2 characters in body
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78
  • with &: 
    =B2-80&"kg or "&(B2-80)*2.2&" lb"lbs"
     5
  • with JOIN(): 
    =JOIN("kg or "; B2-80; (B2-80)*2.2&" lb"lbs")
     5
  • with &: 
    =B2-80&"kg or "&(B2-80)*2.2&" lb"
     5
  • with JOIN(): 
    =JOIN("kg or "; B2-80; (B2-80)*2.2&" lb")
     5
  • with &: 
    =B2-80&"kg or "&(B2-80)*2.2&" lbs"
     5
  • with JOIN(): 
    =JOIN("kg or "; B2-80; (B2-80)*2.2&" lbs")
     5
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

  • with &: 
    =B2-80&"kg or "&(B2-80)*2.2&" lb"
     5
  • with JOIN(): 
    =JOIN("kg or "; B2-80; (B2-80)*2.2&" lb")
     5