# Roundup Function

#### Killer_Bud

##### New Member
Is there a way to round a whole number up to the next whole number in Excel 2000 ? ie: If A3=3, roundup to 4 ? Roundup works great if A3=3.1, but won't roundup to the next whole number if A3=3.

Can anybody help ?

Thanks,

### Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use \$ signs: \$V\$2:\$Z\$99 will always point to V2:Z99, even after copying
Bud,

Wouldn't a simple

=A3+1 work for this? Or are there more conditions?

Cheers,
Matt

Sorry, I should have been more specific. I have a table from L1:T52. Column L has numbers 0-52. A3 for instance would be my id of a gasket.
This table is used to calculate a cost based on this id of the gasket. Price wise, we would like to always roundup to the next whole number should this number be a whole number. I can't use a simple formula such as A3+1 or it will always be adding 1 when I only need it to do this when A3 is a whole number. Is there a condition I can use that: IF A3=A WHOLE NUMBER BETWEEN 1-52, ROUNDUP TO NEXT WHOLE NUMBER ?

If there is nothing I can do I will just have to modify my costs as the time arises with my problem.

Thanks,

=IF(AND(A3=INT(A3),A3<53,A3>0),A3+1,A3)

If the value was 3.59, you want it to stay 3.59?

Seti.....your:
=IF(AND(A3=INT(A3),A3<53,A3>0),A3+1,A3)

works great for the whole number, but if A3=3.4 it's not rounding it
up to 4. I need the best of both worlds on this one.

Thanks,

You said you only wanted it to round up if it was a whole number.

Perhaps:

Without a check for 0-52:

=INT(A3+1)

What do you want to do if it is outside this range?

Maybe:

=IF(AND(A3=INT(A3),A3<53,A3>0),A3+1,ROUNDUP(A3,0))

Seti.....you got it !! That is exactly what I want it to do !!!

Best Regards,

Replies
3
Views
166
Replies
6
Views
166
Replies
10
Views
230
Replies
0
Views
189
Replies
4
Views
308

1,196,044
Messages
6,013,063
Members
441,747
Latest member
darkman77

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back