Hi,
I've been searching the internet for hours and still did not find a solution to my problem.
Basically, I am trying to create a formula that shows me whether there are any mistakes in a row.
For example:
Sheep Dog 0 Cat 500
Sheep Dog 0 Cat 700
Horse Eal 5 Tortoise 100

If the first column is a Sheep, the second one should be a dog and so on... and if all 5 columns are correct and want excel to say "correct".
so far so good:
Formula: copy to clipboard 
=IF(AND(AND(AND(AND(A1="Sheep",B1="Dog",C1=0,D1="Cat",E1=500)))),"correct","incorrect")

That works absolutely fine so far. But Column 5 can also be 700 as seen in row 2, and i can't figure out how to create a formula that accepts either 500 or 700 in column E. That is my main problem.
Now there is a completely different constellation that can also be correct (Row 3), but only in this order (Horse, Eal, 5, Tortoise, 100). How can i combine these two
Formula: copy to clipboard 
=IF(AND(AND(AND(AND(A1="Horse",B1="Eal",C1=5,D1="Tortoise",E1=100)))),"correct","incorrect")


The next step would be to find out in which column the mistake is. For example if C1=8 I want it to say "incorrectC" instead of just incorrect. Any way excel can tell me that?

And my last question (In a new formula only considering A1 and E1)... For A1 i basically get E1 in$. How do I find out how big the deviation between my Value and the actual price is. For example.: A sheep usually gets me 500$ but I only got 300 this time so i made -200$.
Formula: copy to clipboard 
=IF(A1="Sheep",E1-500)
+
Formula: copy to clipboard 
=IF(A1="Horse",E1-100)
. How do I combine these two formulas? I tried to do an OR formula but always got errors.

I hope my questions are understandable.
I very much appreciate your help.
Cheers
John