Round the number

[adrief]

Please help with the formula for the following: (in column j)
If column G has the same number then the bigger one of the two in column I has to be divided into column B then what ever is left needs to be divided by the lesser one in column I. if only one number in column G it must just divide B/I. this must also be rounded down to a solid number.

 

[Nebu]

Hi:

Find the attached. I have constructed the formula as per my understanding, your explanation in OP is not very clear. The formula is an array formula, execute it by pressing Control+Shift+Enter keys. I have constructed formula using helper columns as well, I have used helper column for you to comprehend the formula better, you may just use the one without helper column if you prefer, the logic for both the formulas are same.

Thanks

 

[adrief]

Hi not giving me exactly what i want but you on the right track i have put some explanation in the sheet hope this helps to make it more clear. thank you for your help

 

[Nebu]

Hi:

I have done it using helper column and without helper column but, the formula is bit complex.

Thanks

 

[adrief]

thank you

 

[adrief]

Hi please check my column W is for some reason not pulling through correctly.
Not sure what im doing wrong.

 

[Nebu]

Hi:
The range you have selected was wrong, also the formula I have given is an array formula , you will have to execute it by pressing control+shift+enter key , not just enter.

THnaks

 

[adrief]

Hi the first few on the sheet is working but as you go down more they not giving the correct answers. ive highlighted some in yellow

 

[NARAYANK991]

Hi ,

I am not sure but can you check the attached file ?

Narayan