round an answer

[angelaSPTSA]

hello, i am trying to get the answer to this equation to then be founded up or down per 500.
I have now =ROUND(IF(E3<=17700,0,E3-17700),2) E3 is 42000 the answer now is 24300 I want the answer to be 24000 similar if an answer was 24800 I would want it to show the answer to be 25000
what do I need to add?

 

[Fluff]

Hi & welcome to MrExcel.
You need to use MROUND rather than ROUND.

 

[angelaSPTSA]

Hi & welcome to MrExcel.
You need to use MROUND rather than ROUND.

=MROUND(IF(E3<=17700,0,E3-17700),2) like that?

 

[Fluff]

Not quite, to round to the nearest 500 it would be

=MROUND(IF(E3<=17700,0,E3-17700),500)

or

=MROUND(MAX(0,E3-17700),500)

 

[angelaSPTSA]

Not quite, to round to the nearest 500 it would be

=MROUND(IF(E3<=17700,0,E3-17700),500)

or

=MROUND(MAX(0,E3-17700),500)

thank you! I am super green at this stuff and Im surprised I got this far with the equation. lol I actually need it to be to the 1000 so I put that in and its perfect! thank you so much.

 

[Fluff]

Glad to help & thanks for the feedback.

 

[angelaSPTSA]

Glad to help & thanks for the feedback.

thank you! I was stumped and I learned something!