If a number from I4:I20 is positive than it will show H4:H20.
The formula must show H4 if I4 is positive, H5 if I5 is positive and so on..
An example: if I4=12 , H4=56 than since 12(I4) is positive it will show 56(H4),if I5=123, H5=43 than it will show 43(H5)
Samething for the rest I6=-10, H6=77 than it will not count a negative number and wont show H6.
mrexcel.com/forum/excel-questions/1062489-formula-show-h4-if-i4-positive-number
Bookmarks