From: tonia on 23 Feb 2010 10:53 i cant figure out how to round my final figure UP to the nearest 1,000. i have a list of numbers that are added to a final figure. i need to have that final figure round up to the nearest 1,000, but yet be 15,000.00 or greater so if my total is 26,581.00, i need it to round to 27,000.00 but if my final figure is 3,569.00 it should round to up to 15,000.00 From: Mike H on 23 Feb 2010 11:03 Hi, Try this =MAX(15000,CEILING(A1,1000)) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "tonia" wrote: > i cant figure out how to round my final figure UP to the nearest 1,000. > i have a list of numbers that are added to a final figure. > i need to have that final figure round up to the nearest 1,000, > but yet be 15,000.00 or greater > so if my total is 26,581.00, i need it to round to 27,000.00 > but if my final figure is 3,569.00 > it should round to up to 15,000.00  |  Pages: 1 Prev: how to undo scrolling tied to a single cellNext: Pocket Excel