79347757

Date: 2025-01-11 08:46:44
Score: 3.5
Natty:
Report link

in my case to simplify resistor value

=IF(B1>=1000000; TEXT(B1/1000000; "0.0") & "M"; IF(B1>=1000; IF(MOD(B1;1000)=0;TEXT(B1/1000; "0") & "k";TEXT(B1/1000; "0.#") & "k"); B1))

Resistor k M converter

Reasons:
  • Probably link only (1):
  • Low length (1):
  • No code block (0.5):
  • Low reputation (1):
Posted by: nbctcp