How do I round a number to the nearest .49 in a cell that has a fo

[Butrcup624]

I am a novice, but I think this is close to what I'm trying to acheive. I
have a column of numbers that I need to double whose sum is then added to
itself. Then I need it to round up (.01 - .48) to .49, or (.50 to .98) to
..99. I started with =SUMPRODUCT(E3*50%+E3) but got confused as to how I would
apply the "round" function.

 

[Pete_UK]

Try this around your SP formula:

=CEILING( ... ,0.5) - 0.01

i.e. round it up in increments to the nearest 0.5 and then subtract
0.01 from that.

Hope this helps.

Pete

 

[T. Valko]

E3*50%+E3

Is the same as: E3*1.5

I need it to round up (.01 - .48) to .49

What if E3*1.5 = a whole number like 150?

Maybe this:

=CEILING(E3*1.5+0.01,0.5)-0.01

0 to 0.49 rounds to 0.49
0.5 to 0.99 rounds to 0.99

 

[T. Valko]

E3*50%+E3

Is the same as: E3*1.5

I need it to round up (.01 - .48) to .49

What if E3*1.5 = a whole number like 150?

Maybe this:

=CEILING(E3*1.5+0.01,0.5)-0.01

0 to 0.49 rounds to 0.49
0.5 to 0.99 rounds to 0.99

 

[Butrcup624]

I think both answer were the same, but worded a little differently. But it
worked!!! Thank you!

 

[T. Valko]

I think both answer were the same, but worded a little differently.

No, they don't work the same.

E3 = 20

E3*50%+E3 (or E3*1.5) = 30

One formula returns 29.99 and the other returns 30.49.