Problem with if command

[GarryFreeman]

Good Afternoon.
I am hoping someone can help me with the below.
I am running a report that shows sales by item number which I then need to group as categories as in G3 below. However if a credit is raised it does not reference a item number (B2)
What I am trying to achieve is if C2 is a negative then it returns "Credit" and if it has a sku number then it returns a category such as Brand A from the array table, and if the SKU number is not in the table array then returns "B2B"

Is this at all possible?

Many Thanks in advance

Garry

 

[GarryFreeman]

Ok, I realise how silly my question was now..... put "-" in the array table...

 

[Fluff]

Try changing C2<"0" to C2>=0