I have 3 values (dimensions actually) that I need to compare to 3 other values.
Say the constraining values are 30 inches, 20 inches, and 10 inches, I need to compare the three values to them. All values must be below those, and the values that are coming in aren't in an order as it is height width and depth but one isn't always bigger than another. If the shipping box is 30 by 20 by 10 then somethings dimensions could be 8 by 8 by 8, or 29 by 15 by 10, but 21 by 11 by 11 wouldn't work. Does that make since? If any value exceeds the 30 x 20 x 10 constraint I need it to do something else.
For some reason I can't figure out a simple way to do this and I know there should be one. I'm about to crack open a beer and try it but figured one of you may be able to help.
Thanks!
Also if it could highlight the three value boxes red or just one of them red that would be great too but might be a bit too complicated.
Maybe I didn't understand your problem, but maybe this will help ...
If statement.xlsx
In A2:C2 you define your 30 x 20 x 10
With =IF(OR(E5>A$2;F5>B$2;G5>C$2);"NOT OK";"OK") you compare W or H or D with those in A2:C2
Cheers, Marko
Last edited by DiCaver; 02-03-2012 at 10:45 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks