Forum Discussion
Formula HELP!!
OK so I have 4 cells and I need the below 2 cells have separate formulas to determine amount (D26, I26) I have one set cell (B11) that changes with only a sum of 2 other cells Then the cell in ...
Hi Nicki,
When perhaps
=(D26=0)*((I26<>0)*MAX(I26,B11)+(I26=0)*B11)+(D26<>0)*((I26=0)*MAX(D26,B11)+(I26<>0)*MAX(B11,D26,I26))
if consider all possible combinations.
It's in attached file
Hi Sergei,
Sorry yes I was not good at explaining it. I want B28 to give me if D26 is zero then the greater of I26 or B11 OR if I26 is zero then the greater of D26 or B11.
Does this make sense now?
Hi Nicki,
When perhaps
=(D26=0)*((I26<>0)*MAX(I26,B11)+(I26=0)*B11)+(D26<>0)*((I26=0)*MAX(D26,B11)+(I26<>0)*MAX(B11,D26,I26))
if consider all possible combinations.
It's in attached file
Thanks so very much Sergei.
This formula works perfectly. Your amazing. This was way too complicated for me to work out.