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

--
Biff
Microsoft Excel MVP


"Butrcup624" wrote in message
...
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.