round up to next whole number

N

Nancy Lee

I have a summed calculation that adds two values and then divides the
by one value
I now have to roudup but to a new even number
22.10 should be rounded to 24.00
23.00 should be rounded to 24.00
19.01 should be rounded to 20.00
I am very new and hope I have provided enough data for what should be
simple enough formula - just can't get i
 
F

Frank Kabel

Hi
sorry missed the even part. See your post in Excel.newusers to use
either
=ROUNDUP(A1/2,0)*2
or
=CEILING(A1,2)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Round up to the next number in the set 7
I need to round in the middle of a formula 1
MOD and Ceiling formula used to round up and down to 49 and 99 3
Rounding to every 5th whole number 4
Round up to a specific figure 4
Using value from 2 tables to fill a cell 3
ROUND 2
round up calculations 4

Top