Rounding numbers

[ahhhmed]

Hi,

I want to divide the sum of 4 cells (A1:D1) by 3.

I want to have the results as follows:

I want to delete decimal numbers that are less than one third

I want to round decimal numbers between One third to less than two thirds to 0.5

I want to round decimal numbers that are Two thirds and up to 1


Can anyone help me with the formula?

 

[dan_l]

didn't we just help you with this one?

 

[ahhhmed]

Yes, the formula you sent did not produce the desired results.

 

[Luke M]

So that we don't waste time repeating what was done before, link to other post:

http://chandoo.org/forums/topic/simple-formula


Ahhhmed, your last post in other thread said your formula was working. What changed?

Also, simply saying "It didn't work" is not helpful. What result did you get, and what result did you want? This will help us better identify the problem and/or solution.

 

[Hui]

Ahhhmed

Please refer to comments in your original post.