Formula to show H4 if I4 is a positive number?

[PhilipeC]

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 will show 56(H4),if I5=123, H5=43 than it will show H5
samething for the rest I6=-10 H6=77 than it will show 0 because I6 is negative, and so on...

 

[footoo]

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

 

[Macropod]

PhilipeC : You have been asked multiple times now not to start duplicate threads. Kindly read Rule 12 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html). Thread closed.