Rounding numbers up that are less than one

[amlagu]

Is there a custom format I can use to cells that round all cells less than 1 to 1, but leave any numbers greater than 1 as is? eg 0.25 needs to be rounded to 1, but 1.25 needs to be left at 1.25. Thank you

 

[Rick Rothstein]

Give this Custom Format a try...

[<1]1;General

 

[amlagu]

That works. Thank you very much