Help please: How to get whole numbers to round to the nearest 99

[laurenjl23]

Example:
$550 I need to round to $599.
$2735 I need to round up to $2799.

It will always be the last two digits we need to round to 99.

 

[dave3009]

Hi

Try rounding up to the nearest 100 then subtract 1

=ROUNDUP(A2, -2)-1

HTH

Dave

 

[laurenjl23]

That worked! Thank you very much!!!!

 

[dave3009]

Great, thanks for the feedback.

I suggested rounding up as your example suggested this was what you wanted to achieve. However you could easily apply the same to rounding to nearest or down.

Take care

Dave

 

[MarcelBeug]

Just to remark that the nearest 99 for $2735 is $2699, but apparently you always want to round up.