Rounding this IF

[Scott Krause]

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

=IF(30<P4*0.075,30,P4*0.075)

Thanks,

Scott

 

[c_m]

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

 

[Scott Krause]

That gave me an invalid name error.

 

[mosiki]

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

Should work

Mosiki

 

[c_m]

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

 

[Scott Krause]

That was it, thanks Mosiki!