if Formula

[Geo Jul]

Dear All,​

Please I need your help with the formula in A2​

If B2 is empty, give me "revenue."​

If C2 is empty, give me "Expense."​

If Both B2 and C2 are empty, to stay Empty​

If Both B2 and C2 have an entry, give me "Wrong entry."​

Just a note​

Kindly note that I using 365 Vision but most employees at work use the 2016 version​

 

[DanteAmor]

Try:

=IF(AND(B2="",C2=""),"",IF(AND(B2="",C2<>""),"revenue",IF(C2="","Expense","Wrong entry")))

 

[Scott Huish]

=IF(COUNT(B2:C2)=2,"Wrong Entry",IF(COUNT(B2:C2),IF(B2,"Expense","Revenue"),""))

 

[Phuoc]

Try this in A2:

=CHOOSE((B2<>"")+2*(C2<>"")+1,"","Expense","Revenue","Wrong entry")

 

[Geo Jul]

Try:

=IF(AND(B2="",C2=""),"",IF(AND(B2="",C2<>""),"revenue",IF(C2="","Expense","Wrong entry")))

I do appreciate your response and your perfect solution

 

[Geo Jul]

=IF(COUNT(B2:C2)=2,"Wrong Entry",IF(COUNT(B2:C2),IF(B2,"Expense","Revenue"),""))

I do appreciate your response and your perfect solution

 

[Geo Jul]

Try this in A2:

=CHOOSE((B2<>"")+2*(C2<>"")+1,"","Expense","Revenue","Wrong entry")

I do appreciate your response and your perfect solution