Conditional row addition

[tikrit]

Hello again,

I have a programming problem with Excel.
Let's say I have the following table which has four rows and six coloumns (Neglect the dots).

.....A ..B ..C ...D ...E ...F
1 ..35 .42 .48 .77 ........2
2 ..50 .60 .56 .87 ........0
3
4

I want to do the next: I want to check whether the number in cell F match number 2, Which in this case it does with row 1 only. Then if ok, I want to fill row number 3 with numbers in row 1 but with adding 2 to the first element less than 50 only.
In this case after solution the table must look like:

.....A ..B ..C ...D ...E ...F
1 ..35 .42 .48 .77 ........2
2 ..50 .60 .56 .87 ........0
3 ..35 .42 .50 .77
4 ..50 .60 .56 .87



Is there any formula I can use ?

Thanks in Advance

[arlu1201]

I want to fill row number 3 with numbers in row 1 but with adding 2 to the first element less than 50 only.

Do you mean the number which is less than 50 but the difference of 50 minus the number is the least?

Also, why is row 2 duplicated in row 4 when there is 0 in column F of row 2?

[tikrit]

Do you mean the number which is less than 50 but the difference of 50 minus the number is the least?

Also, why is row 2 duplicated in row 4 when there is 0 in column F of row 2?

Yes , It must be less than the number in column F which in this case is = 2. That means the new row must be the same as the old one except adding 2 to the nearest number less than 50 (which is 48 in row 1).

Row 2 duplicated beause the condition in column F is not satisfied ( the condition of row 2 must have number 2 in column F).

I know it is a little bit complicated but I hope it is a good challenge for you.
Thanks

[arlu1201]

You mean 2 is added to C1 = 48 just because 50-2 gives 48?

What if C1 was 47? Would it be ignored?

[tikrit]

You mean 2 is added to C1 = 48 just because 50-2 gives 48?

What if C1 was 47? Would it be ignored?

The code must check all the elements in row 1 and look what numbers less than 50 by 2. Then add 2 to the element to make it 50. So Yes.
If C1 was 47 it must be ignored in that case.And leave the row beacause there is no number less than 50 by 2 only (just like row 2).
Thanks

[arlu1201]

Do you have a sample file that you can upload?

[tikrit]

I have attached xlsx file as an example.
look at the golden cells. They only change because there is 2 in column F.

Hope you help me with this.

[tikrit]

@arlu1201

I think you have not figure out a solution for my problem, have you ?

[martindwilson]

i cannot see any logic in your result

[tikrit]

@Martin
I explained it. even I uploaded a file.
Can you tell what is the unclear ?

[martindwilson]

all of it!

[arlu1201]

Why is 37 highlighted in the output given (column A) ?