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