If a number from i4:i20 is positive than it will show h4:h20, if its 0 or empty than it will show 0
the formula must show h4 if i4 is positive, h5 if i5 is positive and so on if any number from i4:i20 is 0 or empty than it will show 0.
Such as if i4=12 , h4=56 than since 12(i4) is positive it...
The condition of this formula is the following:
If any number from I4:I20 is positive than in the same row C4:C20 number will be considered:
So if I4=232 THAN C4=13 WILL BE CONSIDERED
if I5=-323 than C5=43 WILL NOT BE CONSIDERED
IF I4:I20 HAVE POSITIVE NUMBERS THEN THE SAME ROWS C4:C20...
I want a formula to calculate the percentage of positive numbers from I4:I20, an example if i4=10 i5=32 i6=100 i7=6 i8=-43 i9=-90 , than: 4/6 are positive numbers than 66.6% is the percentage of positive numbers.
Duration time is:
F4:F20 IS ENTRY TIME FROM I4:I20
D4:D20 IS EXIT TIME FROM I4:I20
DURATION TIME(X) IS F4:F20 - D4:D20
Such as if D4= 11:00 AND F4= 12:00 than (EXIT TIME)F4- (ENTRY TIME)D4 = 12:00 - 11:00 = 1:00 , Duration time is 1:00
I want to find the AVERAGE duration time of positive...