Formula Trouble

[The_Rock]

Hi, the following formula is throwing a 'FALSE' message back:


=IF(BD5="Rejected",IF(OR(AR5="Disengaged 0 PCT",AR5="Loss 0 PCT"),"No"),IF(AS5>BF5,"Yes","No"))

I thought the last if statement would cover the scenario where the result = Rejected and is not flagged as Disengaged or Loss
I've tried changing the formula around but cannot get a satisfactory result.

I maybe looking at this with tunnel vision - appreciate your help with this

 

[Jonmo1]

You have a misplaced )

=IF(BD5="Rejected",IF(OR(AR5="Disengaged 0 PCT",AR5="Loss 0 PCT"),"No"),IF(AS5>BF5,"Yes","No"))
should be
=IF(BD5="Rejected",IF(OR(AR5="Disengaged 0 PCT",AR5="Loss 0 PCT"),"No",IF(AS5>BF5,"Yes","No")))


But there is still nothing in the False part for the first IF
So if BD5 DOES NOT = Rejected, then the formula just returns FALSE.
your result for that scenario should go after the red )

 

[The_Rock]

Thanks Jonmo1, you are a star as usual

I think I managed to fix it by repeating my last criteria - its given me the result I needed:
=IF(BD5="Rejected",IF(OR(AR5="Disengaged 0 PCT",AR5="Loss 0 PCT"),"No",IF(AS5>BF5,"Yes","No")),IF(AS5>BF5,"Yes","No"))