Jak
Well-known Member
- Joined
- Apr 5, 2002
- Messages
- 833
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
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