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
Nicki, could you please clarify the logic, last part
if D26 = 0 then if I26 >=B11, I26 or if I26 , B11,B11.
and my understanding you compare with I26 if only D26=0, otherwise that's max of D26, B11
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.
