Problem divide if

[JuanpaRamone]

Hi all, i'm having problems with a formula.

I want to divide the number in column B between the value in column H, depending on values on colums A and G to match

I have some meassurements of individual cells, and I want to make a ratio between some of those values. For the cells I have a diameter (unique value per cell) and many cell projections (variable number per cell). I want to divide the neurite (cell projection) length between the cell diameter, so I have a ratio.

I've made a formula, but it only works for one cell, when it comes to the second one it fails.

I attach an example so you can see better where the problem is.

Thank you very much for your help!!

JP

[mcmahobt]

If I interpreted your problem correctly, paste this into cell D2 and drag down:

Please Login or Register  to view this content.

[Speshul]

Try this:

=B2/VLOOKUP(A2,$G$2:$H$21,2,0)
Or
=SUMPRODUCT((A2=$G$2:$G$21)*(B2/$H$2:$H$21))


Your IF function is only looking at the first item in the array (because the formula is only entered one cell a time), C1, so it is not working if C1 isn't matched.

[JuanpaRamone]

If I interpreted your problem correctly, paste this into cell D2 and drag down:

Please Login or Register  to view this content.

Thank you very much!!! It works perfect!!!

[JuanpaRamone]

If I interpreted your problem correctly, paste this into cell D2 and drag down:

Please Login or Register  to view this content.

Thank you very much!!! It works perfect!!!