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.
Bookmarks