i4i20

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.

I want to count the sequence of positive number from i4:i20, if i4:i20 there more than one positive number than it will count the sequence, but only if there more than one positive number from i4:i20?

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...

How to find the highest positive number above 0 from I4:I20?

I would like a formula to find the highest number above 0 from I4:I20 and another formula to find the lowest number below 0 from I4:I20?