Recursively Update Cell Values to Make Sum of Range Match Given Number

Hello dear members

My problem is that i want to solve this task, well, let's assume i have numbers in the row

10 - cell B2
15 - cell B3
20 - cell B4
50 - cell B5
55 - cell B6

H5 is some random cell, where written some random valve.
now i want to write a function: IF Range B2:B6 greater/equal/less than H5, then B2:B6-H5/720, and let's assume that the result is 2, then plus 2 to

cell B2 +2
cell B3 +2
cell B4 +2
cell B5 +2
cell B6 +2

thank you in advance.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

I would normally improve the title for a newcomer, however I am afraid I have no clue what you are trying to do - sorry.

Agree with Ali that is is hard to make out what you want here?

Are you saying that you have a set of values in the range B2:B6, the sum of those values gets compared to another value in H5. If that total is "greater/equal/less" H5...and that part males NO sense, as the answer will ALWAYS be greater/equal/less...then adjust the values in B2:B6 by a certain factor?

If that is indeed what you are trying to do, you wont be able to do that with a formula (not without creating a circ ref error), you would need VBA for that.

However, I think you need to walk us through what you are trying to do here, so we can understand exactly what you are trying to do.

Dear members thanks for your response

i will try to simplify the question

10 - cell B2
15 - cell B3
20 - cell B4
50 - cell B5
55 - cell B6

how to write function: IF sum of Range B2:B6 greater H5, then (B2:B6)-H5=result

after all i want to add the result to this cell, like

10 - cell B2 + result
15 - cell B3 + result
20 - cell B4 + result
50 - cell B5 + result
55 - cell B6 + result

well to better understand what my question is for instance IF sum of Range B2:B6 greater H5, then (B2:B6)-H5=2 <-- (i want to calculate this numbers, now it just i random number)
in the cell will be
12 - cell B2
17 - cell B3
22 - cell B4
52 - cell B5
57 - cell B6

as you can see they raised with two

This cannot be done without VBA.

I am going to attempt to update your title (in future you MUST provide descriptive thread titles yourself) and move this to the VBA section.