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


"T. Valko" wrote:

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.