Combining 2 arguments to get a result in 1 cell.

[LShepherd]

I am trying to combine these 2 arguments:


=IF($B$4>BF10,"YES","")

=IF(H10="S","","SUB")


They work alone, but not together, or I am too tired to figure it out.... Can someone help me... what am I missing here?

Situation I am doing.... I have a cell telling me if a player is past due on their membership fees. However if they are a sub (for a bowling league) they will never be behind, I have a different cell (H10) I mark as "S" to identify that player as a sub. If H10 has an "S" in it, I want the argument (cell) to ignore the "YES" statement, or change that statement to "SUB" so that it never says that the sub is behind.

Thanks in advance!

[shukla.ankur281190]

Perhaps

=IF($B$4>BF10,"YES",IF(H10="S","","SUB"))

[Crooza]

I am trying to combine these 2 arguments:

If H10 has an "S" in it, I want the argument (cell) to ignore the "YES" statement

Based on this explanation I think you want it around the other way

=IF(H10="S","",if($B$4>BF10,"YES","SUB"))

[LShepherd]

Thank you guys!! Using Crooza's example worked!!