Sep 11 2019 05:49 PM
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?
Thanks
Sep 11 2019 09:25 PM - edited Sep 11 2019 09:26 PM
Sep 11 2019 09:25 PM
Hi @hilsy12
You can use round() function with if() and achieve desired result.
=IF(E3>=1000000,ROUND(E3,0),E3)
Attached file is also attached for your reference.
Thanks
Tauqeer
Sep 11 2019 09:28 PM
@tauqeeracma But if the cell is formatted to show with decimals, the rounded number will still show with .00 at the end