adeel1 wrote: ↑02 Jan 2022, 15:08

how i can break below formula in pieces for make workable

Adeel, I believe that your specific problem has been solved, but as a general principle I try to use any programming language as a means to condense two parameters into one result.

If you imagine (in any language) a formula that combines (a,b,d,e,f,g,h) into a desired result q, then you can write it as a complicated function that takes eight parameters

or

you can write four functions that take two parameters each:-

a,b --> w

c,d --> x

e,f --> y

g,h --> z

Those four functions will be simple, easy to understand in isolation and easy to test in isolation.

Then you can write two more functions that take two parameters each:-

w,x --> m

y,x --> n

Those two functions will be simple, easy to understand in isolation and easy to test in isolation.

Then you can write one more function that takes two parameters:-

m,n --> q

It may seem like a lot of work to write seven functions instead of one function, but my experience is that the elapsed time from idea to result is much shorter.

In a spreadsheet of course, we use columns to calculate those intermediate results (w, x, y, z, m, n) and hide the columns away somewhere.

Cheers

Chris