Rounding Up

[William Lohse]

I need a little help with a form of rounding. i'm looking for a formula for rounding up to 2 places. my example is $1.2001 i need to round up to $1.21. Help!!!

 

[Expiry]

If that was in A1

=ROUNDUP(A1,2)

 

[VoG]

Try

=ROUNDUP(A1,2)

 

[barry houdini]

Try using either CEILING

=CEILING(A1,0.01)

or ROUNDUP

=ROUNDUP(A1,2)

 

[William Lohse]

Thanks, everyone.