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,
Perhaps
=IF(D26,MAX(D26,B11),MAX(I26,B11))
Hi Sergei,
I have tried your suggested and I get the #value error?
D26 is currently at 0 and I26 is currently at a value which is lower than B11.
