0

Hello How I can round that number without using custom formats like this "[>999999]0.0,,\M;[>999]0.0,\K;0" 1

Because if y use the custom format with this formula '="EXAMPLE "&E24' puts the value without that format.

2

Miguel
  • 35
  • 4
  • `="EXAMPLE"&convert(A3;"g";"kg")&"K"`, will give `EXAMPLE77,7K`. If you add the proper rounding, you should be able to get `EXAMPLE 77K` – Luuk Nov 16 '20 at 18:23

1 Answers1

1

try:

="example "&IF(A1<1000, A1,
 IF(A1<1000000,       TEXT(A1/1000,          "#.0")&"K",
 IF(A1<1000000000,    TEXT(A1/1000000,       "#.0")&"M",
 IF(A1<1000000000000, TEXT(A1/1000000000,    "#.0")&"B", 
                      TEXT(A1/1000000000000, "#.0")&"T"))))

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124