Multiple IF AND OR statements

[kelstar]

This is my first ever attempt at a forum, will do my best to make sense!

I am trying to do the following in one formula:
1. If cell O6 has "-" or cell BD6 is blank, then insert "-"
2. If Y6>=25%, then take MIN(B6:F6)
3. If O6>=25% then take E6 otherwise do BD6/(1-0.25)

This is the formula I have written, but it is returning #VALUE! and I can't figure out what I am doing incorrectly.
NB: $DN$101 = 25% and $DP$101 = 0.25

=IF(AND(O6="-",OR(BD6="","-")),IF(Y6>=$DN$101,MIN(B6:F6)),OR(O6>=$DN$101,E6,(BD6/(1-$DP$101))))

Thank you to anyone who can help me!

 

[sanrv1f]

Welcome to the board,

try this

=IF(OR(O6="-",BD6=""),"-",IF(Y6>=$DN$101,MIN(B6:F6),IF(O6>=$DN$101,E6,BD6/(1-$DP$101))))

 

[Michael M]

Hi Kelstar and welcome to the Board.

a couple of questions

What if
2. If Y6>=25%, then take MIN(B6:F6) .....is less than ??
3. If O6>=25% then take E6 otherwise do BD6/(1-0.25)....is less than ??

Try, untested

=IF(OR(O6="-",BD6="-"),"-",IF(OR(Y6>=$DN$101,O6>=$DN$101),MIN(B6:F6),BD6/(1-$DP$101)))

 

[kelstar]

Thank you Sankar that's exactly what I needed