Pricing variances for comparison

I am working on another variance if statement. It seems I can not get this one the way I initially intedended. Is there anyone out there that can help with this?
I am trying to do a comparison across the 3 stores for any at all price variance. I have 3 stores that list 3 values. In a perfect world the price would be equal but of course it isn't. You can see what I am talking about on the attached file. I am trying to find out which store has a variance and if so what the $ amount is. I have some of the if an statement but I dont think I have it down completely as I am asking for help. Please see the attached file.

I think you attached the wrong file. I don't see any prices.

Copy this formula in cell D2
=IF(AND(A2=B2,B2=C2),"No Variance",IF(AND(A2=B2,B2<>0),"Variance in 3",IF(AND(A2=C2,C2<>0),"Variance in 2",IF(AND(A2=B2,B2=0),"Variance in 1&2",IF(AND(B2=C2,C2=0),"Variance in 2&3",IF(AND(B2=C2,C2<>0),"Variance in 1","Variance in 1&3"))))))
Copy the formula down to row 9

Copy this formula in cell E2
=IF(AND(A2=B2,B2=C2),"No Variance",IF(AND(A2=B2,B2<>0),ABS(B2-C2),IF(AND(A2=C2,C2<>0),ABS(A2-B2),IF(AND(A2=B2,B2=0),ABS(B2-C2),IF(AND(B2=C2,C2=0),ABS(A2-B2),IF(AND(B2=C2,C2<>0),"Variance in 1",ABS(A2-B2)))))))
Copy the formula down to row 9





Kirk

Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)