Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Multiple comparison test, help sought THIS TOPIC IS NOW CLOS

  1. #1
    Board Regular Jak's Avatar
    Join Date
    Apr 2002
    Location
    Newcastle upon Tyne
    Posts
    796
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I need help to test three probable scenarios on a row-by-row basis if the area has been used.

    The user may enter a Time in the following format i.e. 08:30, in three different combinations in a row as follows:

    Example No(1)C18,D18,E18 OR
    Example No(2)C18,D18,F18 OR
    Example No(3)F18

    Once the user has finished entering their times, cell I18 calculates the hours based on the combination of times entered.

    If I18 is =<-0.08027778 which is 2:01 hours and one of the three combinations has been used then a MsgBox needs to pop up to inform of the deficit. In short if one of the three combinations entered causes a deficit of 2:01 or greater in a cell in column "I" then an MsgBox pops up. This 3 in 1 test needs to loop through each used row. If none of the three combinations is true then no comparison is performed.

    The first row in the range is 18. The last row is 43, columns C:F tested against I.

    Any assistance on testing this multiple comparison would be welcomed.


    [ This Message was edited by: Jak on 2002-07-15 23:49 ]

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Jak,

    This seems reasonable, but please provide more detail in these three cells which create your result. What are the formulas and what do they mean (if we cannot decipher them from the post)? Also, is there only one time criteria to test?

    Regards,
    Jay

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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