Help with multiple IF / OR / AND statements

[kelstar]

I need a hand with multiple IF, AND, OR statements.
I am trying to do the following:

1. If AK5 and BF5 are both >= 34%, then take MIN(AK5,BF5).
2. If AK5<34% and BF5>=34%, then take BF5
3. If AK5>=34% and BF5<34%, then take AK5
4. If AK5 and BF5 are both < 34%, then do (G5/EX*MARKUP)+(G5/EX))

I have named a cell MINMARG, value is 0.34.
This is my attempt at the formula

=IF(OR(AK5>=MINMARG,BF5>=MINMARG),MIN(AK5,BF5),IF(OR(AK5<MINMARG,BF5>=MINMARG),BF5,IF(OR(AK5>=MINMARG,BF5<MINMARG),AK5,((G5/EX*MARKUP)+(G5/EX)))))

But it is returning 0. Can't quite figure out where I am going wrong.
Any help would be appreciated.

 

[kelstar]

Apologies, I can't seem to get the rest of my attempt at the formula to copy into this forum!

 

[Michael M]

Try, Untested

=IF(AND(AK5>=MINMARG,BF5>=MINMARG),MIN(AK5,BF5),IF(AND(AK5<MINMARG,BF5>=MINMARG),BF5,IF(AND(AK5>=MINMARG,BF5<MINMARG),AK5,((G5/EX*MARKUP)+(G5/EX)))))

 

[kelstar]

Thanks Michael,
I should have said I already tried substituting AND for OR, that still returns a zero value.

For some reason I can't get my whole attempt at the formula to post into the thread. Whenever I preview it, parts have been removed.

 

[jasonb75]

Try

=IF(MIN(AK5,BF5)>MINMARG,MIN(AK5,BF5),IF(MAX(AK5,BF5)<=MINMARG,(G5/EX*MARKUP)+(G5/EX),MAX(AK5,BF5)))


With regard to your vanishing formula, in some instances the board interprets < and > as html, you can prevent the problem by putting a single space before and after each < or > , or by wrapping the formula with php tags.

 

[kelstar]

Jason, thanks for your help, that worked perfectly