"Rounding Column A to a certain value when column A is between number x and number y"

[SMJ2992]

Hello All,

I am hoping some one is able to perhaps shed some light on the following road block i've hit...

Okay, I have four values:

.25
.50
.75
1.00 ( im not sure if 1.00 is correct...it needs to represent rounding up to the next integer)

These values are achieved depending on the decimal value of let's say, column A. Column A has values running from 0.00-1.00 ; the decimals represent minutes.
In order for a value from column A to be rounded to one of the four original values listed, the following parameters exist:

a value in Column A rounds to .25 when that value is between .01 and .39
a value in Column A rounds to .5 when that value is between .4 and .64
a value in Column A rounds to .75 when that value is between .65 and .89
a value in Column A rounds to 1.00 ( the next integer) when that value is between .9 and 1.00

Does anyone have any ideas on how I can achieve this?

Please let me know if further explanation is needed of if the clarity of the question is lacking.

Super Duper Thanks in Adavance!

[FlameRetired]

SMJ2992 welcome to the forum.

Try this in B2 as below and fill down.

Please Login or Register  to view this content.

	A	B
1	Numbers	Return This
2	0.85	0.75
3	0.35	0.25
4	0.33	0.25
5	0.60	0.5
6	0.87	0.75
7	0.91	1
8	0.53	0.5
9	0.04	0.25
10	0.07	0.25
11	0.02	0.25
12	0.67	0.75
13	0.81	0.75
14	0.31	0.25
15	0.53	0.5
16	0.24	0.25
17	0.25	0.25
18	1.00	1
19	0.98	1
20	0.88	0.75
21	0.16	0.25

[SMJ2992]

Oh my yes!

Thank you Dave!!!

I really appreciate your assistance on this. Aside from the answer, I also now realize what question I wasn't asking myself when trying to fix this issue.

Have a great one and many many thanks!

[FlameRetired]

Good to hear! Thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.