Hello all!
I am trying to compare values in G2 and H2 based on the below criteria:
I started with the below formula, but it doesn't take into consideration if one cell is blank and not the other or if they are the same. Any help is greatly appreciated!
=IF(AND(ISBLANK(G2), ISBLANK(H2)),"",IF(G2>H2), "Sales_Initiated", "Marketing_Initiated"))
I am trying to compare values in G2 and H2 based on the below criteria:
- Both are date fields
- If G2>H2 then "Sales Initiated"
- If G2<H2 then "Marketing Initiated"
- If G2=H2 then "Marketing Initiated"
- If G2 is blank, but H2 is not, then "Sales Initiated"
- If G2 is not blank, but H2 is blank, then "Marketing Initiated"
- If both G2 and H2 are blank, then ""
I started with the below formula, but it doesn't take into consideration if one cell is blank and not the other or if they are the same. Any help is greatly appreciated!
=IF(AND(ISBLANK(G2), ISBLANK(H2)),"",IF(G2>H2), "Sales_Initiated", "Marketing_Initiated"))