How do I round a number to the nearest .49 in a cell that has afo
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
On Jul 2, 10:11*pm, Butrcup624
wrote:
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.
|