Help with creating a formula based on one cell to multiple rows in different columns

[pri_GIS]

I need one help. I am trying to create a formula that relies on a single cell which compares multiple rows from different columns. In my spreadsheet, I have approx. over  90,000 records. Attaching a sample dataset. 

[geraldo]

@pri_GIS 

Sorry, I didn't understand what you want.
the input and output was not clear and neither was the analysis that was made for the data.

[pri_GIS]

Sorry about that. It's just that this is one of the step in my analysis.

I would like to simplify the problem.

In this case A1 should interact with all rows in Column B,C and D. 

Hopefully this is helpful.

[Qiu]

@pri_GIS 
The problem is not clear to me either.
Can you give the definition of "Result" and "Max"?

I feel it is an Append issue as below but need more input.

[Raj]

do you want to create formula for Result and Max or need to create every column?

[Raj]

formula for result : If [Dist]>=[Source_variable] and [Dist]<=([Source_variable]+[Source_Length]) then [Source_Percentage] else 0 endif

[Raj]

Find the complete solution,

Hope this help.

[pri_GIS]

Thank you @Qiu and @Raj. I tested the workflows. It works great.

Appreciate you both looking in to this and helping me out. Your workflow is very efficient. 

[Qiu]

@pri_GIS 
Good to know it helps somehow.