Hi,

I am new to Excel.

I have a spread sheet with hundreds of retail prices.

I need to round up or down.
Example: $2.58, $2.42

< .5 would be rounded up... ex: $2.58 would round up to $3
> .5 would be rounded down...ex $2.42 would round down to $2

What is the formula to accomplish this without doing each one separately?

Thanks a lot for your help.

75