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

[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-questions/1062489-formula-show-h4-if-i4-positive-number.html

 

[Macropod]

PhilipeC : You have been asked multiple times now not to start duplicate threads. I see you've also cross-posted this topic @ https://www.excelforum.com/excel-general/1237295-formula-to-show-h4-if-i4-is-a-positive-number.html. Kindly read Rules 12 & 13 (http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).

Note to anyone else reading this thread : No further replies should be posted until PhilipeC acknowledges the requirements of Rules 12 & 13.