View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rdwngr23 rdwngr23 is offline
external usenet poster
 
Posts: 8
Default rounding to nearest 100

is there a way to have a cell round to the nearest 100 up and or down?

if i have 4.595 i would like it to round up to 5 but if i change it 4.493 i
would like it to round down to 4.

looking for a formula that would work for both in one cell