How to round up a excel value to the nearest quarter in excel

[rv_ui (Ravi)]

Hello,

I need help rounding up values to nearest quarter in excel. For example if I have values between 0.01 to 0.24 I need to round them up to 0.25 and so on… I tried the round up method and all it is rounding up to is the nearest decimal value. Could someone please help me with this?

Thanks

[Anil_G (Anil Gorthi)]

@rv_ui

Welcome to the community

Try this formula in your excel

=ROUND(A1*4,0)/4

A1 is where you will have the original value

Cheers

[rv_ui (Ravi)]

@Anil_G

the original value

Is there any way I can do that in Studio? like write a program or an expression

Thank you for your response

[rv_ui (Ravi)]

I tried that and it is not rounding up to the way I wanted. So if I do
=ROUND(0.01*4,0)/4

0.01 is the value in the excel, I am getting 0.00 as the output, but the business need them to be rounded up to the nearest quarter which is 0.25

[Anil_G (Anil Gorthi)]

@rv_ui

You can try in excel

=CEILING(A1,0.25)

In Studio not sure…let me try if we can…

You can use write formula and fill range activities to write formula to excel and fill it

cheers

[Anil_G (Anil Gorthi)]

@rv_ui

So in studio as well you can try this

‘Math.Ceiling(var*4)/4’

var is the place where you value is stored…if its a string use cdbl(var) to convert to double

Hope this solves

cheers

[rv_ui (Ravi)]

@Anil_G

Math.Ceiling(var*4)/4

This solved the proble.

Thanks a lot Anil.

I appreciate it!