Make Millions

[skorpion]

i have spreadsheet what i need is if any value have above Million so it become million

 

[Khalid NGO]

Hi and welcome to the forum.

You can use IF function like this:

=IF(B2>1000000,1000000,B2)

Regards,

 

[pecoflyer]

Or =MIN(B2,1000000)