Rounding Up to the next .50

[Spiketrip]

I have a calculation that I wish to round up to the next .50:

ie:
Calculation = 10.25 roundup to 10.5
Calculation = 10.00 roundup to 10.5
Calculation = 9.75 round up to 10.5
Calculation = 10.5 round up to 11.5

Is this possible? I am able to round up to the next .50 but this als
includes the next .00.

Thanks in advance
Mik

 

[Myrna Larson]

This is very kludgy, and somebody will probably have a better solution, but

=INT(A1)+IF(MOD(A1,1)<0.5,0.5,1.5)

I don't understand what you mean by "rounding up to the next .5 includes the
next 0.00". Do you mean that 9.75 rounds to 10.0

 

[Ron Rosenfeld]

I have a calculation that I wish to round up to the next .50:

ie:
Calculation = 10.25 roundup to 10.5
Calculation = 10.00 roundup to 10.5
Calculation = 9.75 round up to 10.5
Calculation = 10.5 round up to 11.5

Is this possible? I am able to round up to the next .50 but this also
includes the next .00.

Thanks in advance
Mike

Perhaps:

=ROUND(A1+1,0)-0.5


--ron

 

[Harlan Grove]

=ROUND(A1+1,0)-0.5

Or just

=ROUND(A1,0)+0.5

 

[Ron Rosenfeld]

Or just

=ROUND(A1,0)+0.5

Duh <slap> (sound of hand hitting forehead)


--ron

 

[Spiketrip]

Thanks for the help. I have encountered another problem during this
process. I need to round up to the next XX.50 after performing a
calculation.

My calculation comes up with 66.50 and I need to round up to the next
XX.50 which would be 67.50. Can this be done?

If my calculation comes up with 66.25 the operation does round up to
the next XX.50 or 66.50.

Thanks again...sounds so easy but ....

 

[JE McGimpsey]

One way:

=ROUND(A1,0)+0.5

 

[Ron Rosenfeld]

Thanks for the help. I have encountered another problem during this
process. I need to round up to the next XX.50 after performing a
calculation.

My calculation comes up with 66.50 and I need to round up to the next
XX.50 which would be 67.50. Can this be done?

If my calculation comes up with 66.25 the operation does round up to
the next XX.50 or 66.50.

Thanks again...sounds so easy but ....

It's the same answer as you previously received.

=ROUND(your_calculation,0)+0.5


--ron