If I4 is positive then it will show H4

[PhilipeC]

The formula must show H4 if I4 is positive, H5 if I5 is positive and so on..
From H4:H20 it will consider only positive numbers from I4:I20, so if there any negative numbers it wont count H



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.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...h4-h20-if-its-0-empty-than-will-show-0-a.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).