rounding numbers

  • Thread starter Thread starter elie
  • Start date Start date
E

elie

hi

i am using office XP. i want the cells to round down.
when the result of a calculation is 1.5 it marks 2 and i
want it to be 1. how can i do that?

thanks
 
Elie,

Use ROUNDDOWN rather than ROUND.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top