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.