Return A Cell With Multiple Criterias

Excellerlearning

New Member
Joined
May 2, 2019
Messages
3
Need all your help. Thank you in advance.

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>
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,213,489
Messages
6,113,949
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top