dandedo2
09-01-2010, 06:01 AM
how do I set up cells so that it would be, for example,
if value > 100 round to nearest whole number
if value< 100 use full number
I have 2 sets of data that are pulled into certain cells, one set is numbers under 5, say 1.2345 which I want expressed that way, whereas the other set is numbers such as 2030.8 which I want simply rounded to the nearest number.
Thank you
if value > 100 round to nearest whole number
if value< 100 use full number
I have 2 sets of data that are pulled into certain cells, one set is numbers under 5, say 1.2345 which I want expressed that way, whereas the other set is numbers such as 2030.8 which I want simply rounded to the nearest number.
Thank you