# Rounding this IF

#### Scott Krause

##### Board Regular
Using Excel 2003, how do I round this IF to the nearest 5 or 0?

PHP:
``=IF(30<P4*0.075,30,P4*0.075)``

Thanks,

Scott

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### c_m

##### Well-known Member
<code style="white-space: nowrap;"><code>=IF(30<P4*0.075,30,MROUND(P4*0.075,5)) </code></code>

#### Scott Krause

##### Board Regular
That gave me an invalid name error.

#### mosiki

##### Board Regular
=(Round((IF(30<P4*0.075,30,P4*0.075))/5,0))*5

Should work

Mosiki

#### c_m

##### Well-known Member
To use MROUND, you have to install Analysis ToolPak (go to Tools>Add-Ins).

#### Scott Krause

##### Board Regular
That was it, thanks Mosiki!

Replies
11
Views
1K
Replies
1
Views
506
Replies
3
Views
1K
Replies
8
Views
407
Replies
19
Views
576

1,191,719
Messages
5,988,292
Members
440,148
Latest member
sandy123

### 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