# i4i20

1. ### If a number from i4:i20 is positive than it will show h4:h20, if its 0 or empty than it will show 0

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...
2. ### C4:c20 average of i4:i20 positive numbers

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...
3. ### Calculate the percentage of positive numbers from I4:I20

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.
4. ### Count sequence 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?
5. ### Find average positive numbers and negative numbers of duration time(X)?

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...
6. ### How to find the highest positive number above 0 from I4:I20?

How to find the highest positive number above 0 from I4:I20?
7. ### Find the highest number and lowest number 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? ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?    1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back