=IF(SEARCH($G$2,C6,1),"Expense1"),IF(D6="",""),IF(D6<0,"Earning"),IF(D6>0,"Expense"),IF(D6=0,"")
=IFS(SEARCH($G$2,C6,1),"Expense1",D7="","",D7<0,"Earning",D7>0,"Expense",D7=0,"")
Both the above functions are giving me an error. This function is respecting only the first criteria to search for G2. Ideally, I want the formula to look for > or < or = if G2 does not match. Help, please.
Thanks...
=IFS(SEARCH($G$2,C6,1),"Expense1",D7="","",D7<0,"Earning",D7>0,"Expense",D7=0,"")
Both the above functions are giving me an error. This function is respecting only the first criteria to search for G2. Ideally, I want the formula to look for > or < or = if G2 does not match. Help, please.
Thanks...