Nested if function with multiple criteria

Hi! Guys,


I have an spreadsheet where I have three conditions:
1. IF B1 and C1 are blank cell, in A1, if true should be "Vendor", if false shall be "Consumer".
2. If B1 has date and C1 is blank cell, if true should be "Consumer", if false shall be "Vendor".
3. If both B1 and C1 have dates but B1 is greater than C1, if true should be "Consumer", if false shall be "Vendor".
4. B1 and C1 obtained dates from other cells by formula.

Thanks.

argandoz

=CHOOSE((ISNUMBER(A2)+ISNUMBER(B2))+1,"Vendor","Consumer",IF(B2>A2,"Consumer",C10))

Hi! Sadath31,

Thank you very much for the response. Base on your given formula, it works for condition 1 and 2 but not when it applies to condition 3. Condition 3 should read as " if B1 and C1 has dates, and B1 is greater than C1, "Consumer" if true and...
Hopefully, you can further help me on this.

Thanks,
argandoz

Try this
=IF(OR(AND(B1=0,C1=0),C1>=B1),"Vendor","Consumer")

This should be enough:

=IF(B1>C1, "Consumer", "Vendor" )

Guys,

Thanks again for everyone. That formula shared by nflsales was perffectly correct and working properly.
Thanks for efforts of others sharing their time and knowledge.

BR,
argandoz