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 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.