Excel Conditional Decimal Places

[hilsy12]

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

[#2]

Hello @hilsy12 ,

you can use custom format

[<1000000]#,##0.00;[>=1000000]#,###

[#3]

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

[#4]

@tauqeeracma But if the cell is formatted to show with decimals, the rounded number will still show with .00 at the end

[#5]

Correct, you are right, thanks