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.

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.

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.

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.

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.

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.


--
Biff
Microsoft Excel MVP


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