MROUND in an IF(AND... Formula

[Snake Eyes]

Greetings,
I would like to round the result of this formula to the nearest 100 but I can't seem to figure out the syntax to include MROUND.

=IF(AND(Z6>=0,Z6<=5),($AJ$1/F6),"")

 

[Fluff]

How about

=IF(AND(Z6>=0,Z6<=5),mround($AJ$1/F6,100),"")

 

[Snake Eyes]

Perfect!!
Thanks Fluff.

 

[Snake Eyes]

If I wanted to round up or down to the nearest 100 I'd assume to replace the MROUND with ROUNDUP or ROUNDDOWN but in doing so the formula does nothing.
What am I missing?

 

[Fluff]

If I wanted to round up or down to the nearest 100

That's what Mround does.
If you always want to roundup, then you would use Ceiling.