Formula HELP!!

[Deleted]

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. 

[#2]

Hi Nicki,

Perhaps

=IF(D26,MAX(D26,B11),MAX(I26,B11))

[#3]

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.

[#4]

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

[#5]

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

[#6]

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? 

[#7 · Accepted solution]

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

[#8]

Thanks so very much Sergei.

This formula works perfectly. Your amazing. This was way too complicated for me to work out.