From: M Thompson on 18 May 2010 18:39 Hi Please-How do you round up to the nearest \$1000.00? Thanks! -- OneFineDay From: Mike H on 18 May 2010 19:06 Hi, Your question is unclear. Do you mean round up to next 1000? =CEILING(A1,1000) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "M Thompson" wrote: > Hi > > Please-How do you round up to the nearest \$1000.00? > > Thanks! > -- > OneFineDay From: M Thompson on 18 May 2010 19:13 You read my mind. That worked perfectly. Thanks! -- OneFineDay "Mike H" wrote: > Hi, > > Your question is unclear. Do you mean round up to next 1000? > > =CEILING(A1,1000) > -- > Mike > > When competing hypotheses are otherwise equal, adopt the hypothesis that > introduces the fewest assumptions while still sufficiently answering the > question. > > > "M Thompson" wrote: > > > Hi > > > > Please-How do you round up to the nearest \$1000.00? > > > > Thanks! > > -- > > OneFineDay  |  Pages: 1 Prev: Macro problemNext: Macro or VB code to hide and unhide Label box