Help with using a result in two IF statements?

[wbstadeli]

Hi Guys,

I have a question about a merging two IF statements together using the result of the first statement in the second statement. I dont know if this is possible, but here it is.... In long-hand this is what i need Cell M15 to equal:

=IF(M21>N21, then M21, else N21, (and here is what i dont know how to merge this, but i want this also), =IF(021>result from first function/B15, then 021, else result from first function/B15.

Thanks for looking!

 

[wideboydixon]

The first IF() is equivalent to:

=MAX(M21,N21)

So your final formula becomes:

IF(O21>MAX(M21,N21)/B15,O21,MAX(M21,N1)/B15)

WBD

 

[RasGhul]

Try

=IF(O21>IF(M21>N21,(M21/B15)),O21,IF(M21>N21,(M21/B15)))

 

[Scott Huish]

The first IF() is equivalent to:

=MAX(M21,N21)

So your final formula becomes:

IF(O21>MAX(M21,N21)/B15,O21,MAX(M21,N1)/B15)

WBD

You could just nest that in another MAX instead of the IF:
=MAX(O21,MAX(M21,N21)/15)

 

[wbstadeli]

The first IF() is equivalent to:

=MAX(M21,N21)

So your final formula becomes:

IF(O21>MAX(M21,N21)/B15,O21,MAX(M21,N1)/B15)

WBD

Works great! thanks a bunch