tonyq 11:47 11 Apr 2008
Locked

Hi All,
please could someone tell if it is possible and if so how to do the following in Excel 2003. I have a list of numbers e.g 1 to 30,I am wanting to multiply these numbers by 0.750 (which I have been able to do) then I need anything below .5 to go to the lower full number.
Anything that is .5 and above rounded up to the next higher full number.
e.g
1 x 0.750 = 0.750 rounded up to 1
7 x 0.750 = 5.250 rounded down to 5

Picklefactory 11:53 11 Apr 2008

=ROUND(B4*0.75,0)
If I've understood correctly, if you put that in your result cell it should round to nearest integer.
Is that what you meant?

Picklefactory 11:54 11 Apr 2008

Should have mentioned I used B4 as source cell and had formula in C4, you can simply click and drag formula down your column.

tonyq 12:16 11 Apr 2008

Picklefactory
thank you that's just what I needed.
Another problem I have and cannot seem to find how to overcome using the "Help"
is when I type 3/4 into a cell it wants to class this as a "Date" please could you tell me how I stop it doing this.

VoG II 12:19 11 Apr 2008

Format the cell as Text before entering 3/4 or type '3/4

Picklefactory 12:20 11 Apr 2008

It will see the / as a delineator for a date eg 3/4/08 if you want to enter a fractional figure eg ¾, then just use =3/4 and the = will make it a sum. It will display as 0.75.

tonyq 13:39 11 Apr 2008

Picklefactory/VoG™
thank you both for your help.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more