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 which I need the formula B28
I want this cell to be If D26 >= B11 then use D26, if D26 < B11 use B11. This part of a formula I can do but struggling with adding another variable - BUT if D26 = 0 then if I26 >=B11, I26 or if I26 , B11,B11.
so Basically either D26 or I26 will have a value and the other will have 0. So I need B28 to give me whichever of D26,i26 OR B11 is the greater amount and return that in the cell.
Any help greatly appreciated.
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 Nicki,
Perhaps
=IF(D26,MAX(D26,B11),MAX(I26,B11))
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
