+ Reply to Thread
Results 1 to 3 of 3

Thread: If statement

  1. #1
    Registered User
    Join Date
    02-02-2012
    Location
    Dallas
    MS-Off Ver
    Excel Mac 2011
    Posts
    2

    If statement

    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!

  2. #2
    Registered User
    Join Date
    02-02-2012
    Location
    Dallas
    MS-Off Ver
    Excel Mac 2011
    Posts
    2

    Re: A complicated if statement?

    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.

  3. #3
    Registered User
    Join Date
    01-26-2012
    Location
    Slovenia; Kranj
    MS-Off Ver
    Excel 2010
    Posts
    32

    Re: If statement

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0