Multiple if commands that checks multiple cells

[neokragu]

Dear All,

I am running a fruit shop. I am buying fruits from many suppliers. I need to arrange all Bill in a singe entry register. I need an excel sheet for my requirement. I will enter all the information like Supplier name, fruit type and quantity in fruits entry sheet. The result expected in fruits summary sheet. I need to check in different cells with if commands.

if(C6=A & D6=Mango & E6=First )

If all the three conditions are ok then quantity should required in specified cell in fruit summary sheet

Expecting your valuable help