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
OK so if D26 has a value higher than both I26 AND B11 it is returning D26 but not working if I26 if the higher of the 3 cells
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
