# Higher/ Lower Full Number Excel 2007

tonyq 13:53 15 Jan 11
Locked

Please can anyone tell me how to do the following in
Excel 2007.
Say I have a list of numbers 1-20 which I need to find 3/4 of each number. Then the results be rounded up to a full number if the result is .5 or above, or rounded down to a full number if below .5

Zak 13:58 15 Jan 11
VoG II 14:03 15 Jan 11

Just ROUND should do

=ROUND(A1*3/4,0)

Zak 14:06 15 Jan 11

Formulas in Columns A, B & C and Rows 2 to 21

1 =A2*0.75 =MROUND(B2,1)
2 =A3*0.75 =MROUND(B3,1)
3 =A4*0.75 =MROUND(B4,1)
4 =A5*0.75 =MROUND(B5,1)
5 =A6*0.75 =MROUND(B6,1)
6 =A7*0.75 =MROUND(B7,1)
7 =A8*0.75 =MROUND(B8,1)
8 =A9*0.75 =MROUND(B9,1)
9 =A10*0.75 =MROUND(B10,1)
10 =A11*0.75 =MROUND(B11,1)
11 =A12*0.75 =MROUND(B12,1)
12 =A13*0.75 =MROUND(B13,1)
13 =A14*0.75 =MROUND(B14,1)
14 =A15*0.75 =MROUND(B15,1)
15 =A16*0.75 =MROUND(B16,1)
16 =A17*0.75 =MROUND(B17,1)
17 =A18*0.75 =MROUND(B18,1)
18 =A19*0.75 =MROUND(B19,1)
19 =A20*0.75 =MROUND(B20,1)
20 =A21*0.75 =MROUND(B21,1)

Result
1 0.75 1
2 1.5 2
3 2.25 2
4 3 3
5 3.75 4
6 4.5 5
7 5.25 5
8 6 6
9 6.75 7
10 7.5 8
11 8.25 8
12 9 9
13 9.75 10
14 10.5 11
15 11.25 11
16 12 12
17 12.75 13
18 13.5 14
19 14.25 14
20 15 15

tonyq 14:08 15 Jan 11

So quick!
thanks to you both.

Zak 14:09 15 Jan 11

Yours is naturally better - I was busy composing post when your post arrived in thread!

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…