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

laurenjl23

New Member
Joined
Jan 26, 2016
Messages
9
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.
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
Hi

Try rounding up to the nearest 100 then subtract 1

=ROUNDUP(A2, -2)-1

HTH

Dave
 

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,002
Office Version
  1. 365
  2. 2016
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

Well-known Member
Joined
Apr 25, 2014
Messages
1,811
Just to remark that the nearest 99 for $2735 is $2699, but apparently you always want to round up.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,186
Messages
5,594,738
Members
413,929
Latest member
Hypatia

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top