How to round number to thousand

Help Forms
5

Hi @sshitol
If(inputNumber Mod 1 = 0, String.Format(“{0:N0}”, inputNumber), String.Format(“{0:N2}”, inputNumber))

Try this.

  1. Mod 1 = 0: Checks if the number is a whole number.
  2. String.Format(“{0:N0}”, inputNumber): Formats the number without decimals.
  3. String.Format(“{0:N2}”, inputNumber): Formats the number with two decimal places.