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 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.