Roundup Function

[Killer_Bud]

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,

 

[hayati]

Bud,

Wouldn't a simple

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


Cheers,
Matt

 

[Killer_Bud]

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,

 

[Seti]

How about:

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

 

[Scott Huish]

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

 

[Killer_Bud]

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,

 

[Scott Huish]

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?

 

[Seti]

Maybe:

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

 

[Killer_Bud]

Seti.....you got it !! That is exactly what I want it to do !!!
Thanks for your help,

Best Regards,