Does anyone know what formula or Conditional format/number that will format dollar values so that pennies are shown only if the amount borrowed is less than one million and anything over a million only shows a whole number?
Hello @hilsy12 ,
you can use custom format
You can use round() function with if() and achieve desired result.
Attached file is also attached for your reference.
@tauqeeracma But if the cell is formatted to show with decimals, the rounded number will still show with .00 at the end