I'm Trying To Crate A Simple Division Formula

[zotah]

I'm Trying To Crate A Simple Division Formula

I have 2 columns of numbers going down a page like this.

Column A...........Column B

4...........................> I need the 4 to be divided by 50% to give and answer in Column B as (2)
1...........................> I need the 1 to be divided by 50% and give the answer of (1)

-6...........................> I need the -6 to be divided by 50% and give the answer of (-3)

-4...........................> I need the -4 to be divided by 50% and give the answer of (-2)

17...........................> I need the 17 to be divided by 50% and give the answer of (-9)

15...........................> I need the 15 to be divided by 50% and give the answer of (8)

27...........................> I need the 27 to be divided by 50% and give the answer of (14)

-1...........................> I need the -1 to be divided by 50% and give the answer of (-1)

Simply stated I have thousands of numbers going down the column and I need each number to the column on the left side to be calulated to the column on its right side to have its value divided by 2 however as you see in the example. If the number to be divided by 2 is an odd number like 27. Then I need the answer to be a whole number with the whole number to be at the higher point.

So if the number is -1 and you divid -1 by 50% it would by -.5 but since the .5 is a fraction I need the number to be the same number as (-1) even though the number comes out the same exact number it started with.

So if the number is and even number then it's ok to exactly divid that number by itself leaving the number to be exactly 50% of the original number like if the number is 14 then the answer would be 7
If the number is 13 then the answer would still be 7

If the number is -19 then the answer would be -10

All negative numbers need to stay negative in the answer and all positive numbers divided need to stay positive.

I need the formula to allow me to drag it down the page so all the answers in the column will be grabed off the column to its left. So I wont have to paste the formula in each and every square to get my answers.

I hope I explained this problem out ok.

Thanks for any help you can give me on this.

Zotah

 

[Teeroy]

Try the following formula for data from A1;

B1: =ROUND(A1/2,0)

and fill/copy down.

 

[zotah]

Try the following formula for data from A1;

B1: =ROUND(A1/2,0)

and fill/copy down.

Formula absolutely works perfectly

Thanks so much. You saved me hours of trying to figure this out.

Zotah

 

[Teeroy]

You're welcome.