Need help on Nested if or IFs

[tinferns]

=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...

 

[AlphaFrog]

=IF(ISNUMBER(SEARCH($G$2,C6,1)),"Expense1",IF(D6="","",IF(D6<0,"Earning",IF(D6>0,"Expense",""))))

 

[tinferns]

One more point is that there could be more than 1 TRUE result. In such cases I am ok for excel to consider the 1st TRUE result and act

=IF(ISNUMBER(SEARCH($G$2,C6,1)),"Expense1",IF(D6="","",IF(D6<0,"Earning",IF(D6>0,"Expense",""))))

That was magnificent AlphaFrog.. it worked. Thanks a ton.. Cheers...

 

[AlphaFrog]

You're welcome. Thanks for the feedback.