Rounding up to specified numbers in a list

[kp1983]

I need to numbers in one column to round up to the nearest number in another column.

Example:

Column A -

2.08
1.08
2.90
5.12
10.83

Column B -

2.65
5.83
12.19
25.97
54.47

I want the values in column A to round up to the nearest values in column B. Is it possible without using lots of IF statements?

[Tony Valko]

Not real clear.

Show us what results you expect.

[bebo021999]

So the answer should be:
2.65
2.65
5.83
5.83
12.19
in C column?
If yes, try in C1:

Please Login or Register  to view this content.

Confirmed with Ctrl-Shift-Enter
Drag down
C column will reflect new values of A column. You can copy/paste value back to A if you want.

[kp1983]

So the answer should be:
2.65
2.65
5.83
5.83
12.19
in C column?
If yes, try in C1:

Please Login or Register  to view this content.

Confirmed with Ctrl-Shift-Enter
Drag down
C column will reflect new values of A column. You can copy/paste value back to A if you want.

hi, yes that would be the correct answer. Will try your formula in a moment. Would it be a pain to update the values in column A?

Column A generates value simply on a % value of a certain number. At the moment A1 says = E1*0.002. This gives me a value of 2.00 (E1 being 1000).

Was hoping theres a way to generate that value and then round up to a value in column B. If not i guess ill have to create new columns

[bebo021999]

If A has value itself, macro is needed. But A value depend on other cell, like this case, try to replace A1 in my formula with E1*0.002, and put the formula from A1 down

[daddylonglegs]

Perhaps try this "array formula"

=MIN(IF(B$1:B$5>=A1,B$1:B$5))

confirmed with CTRL+SHIFT+ENTER

[bebo021999]

Perhaps try this "array formula"

=MIN(IF(B$1:B$5>=A1,B$1:B$5))

confirmed with CTRL+SHIFT+ENTER

I have searched very carefully to make sure that you are not here...