Multiple comparison test, help sought THIS TOPIC IS NOW CLOS

[Jak]

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 ]

[Jay Petrulis]

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