Excellerlearning
New Member
- Joined
- May 2, 2019
- Messages
- 3
Need all your help. Thank you in advance.
<colgroup><col><col><col><col><col><col><col><col><col span="9"></colgroup><tbody>
</tbody>
Cells A1: Total B1: 16000 C1: Total D1: 17000 E1: Total F1: 16500 G1: Total H1: 17250 Row 2 K2: NO M2: NO O2: NO Q2: YES These cells can either be selected as YES or NO. Need the cells B2, D2, F2, H2 to return the number if criterias meet. | ||||||||||||||||
1st Criteria: B2= Find the minimum value of the range $B1:$H1 that is greater than 0. 2nd Criteria: Min value of that range then look at cells $K2:$Q2. If NO, then find any YES of the remaining cells D2, F2, and H2 and multiple 0.5 with the minimum value from $B1:$H1 If YES for minimum value cell, then no further actions needed. Apply 0 to B2, D2, F2, H2. Thanks Again. |
<colgroup><col><col><col><col><col><col><col><col><col span="9"></colgroup><tbody>
</tbody>