Find Minimum Positive Price by Distribution Type by Item Number

[JaneeBaker]

Acctg Doc Num	Material	Wholesale / Retail / Distributor	Sales Price	Min Positive Price - W	Min Positive Price - R	Min Positive Price - D
1400048342	21-36881	R <tbody> </tbody>	-59.99 <tbody> </tbody>	0.00	39.00	49.99
1400048199	21-36881	R <tbody> </tbody>	39.00 <tbody> </tbody>	0.00	39.00	49.99
1400046986	21-36881	D	49.99 <tbody> </tbody>	0.00	39.00	49.99
1400047588	21-36881	D	59.99 <tbody> </tbody>	0.00	39.00	49.99
1400047654 <tbody> </tbody>	21-36881	R <tbody> </tbody>	59.99 <tbody> </tbody>	0.00	39.00	49.99
1400045684	21-36883	R <tbody> </tbody>	-79.99 <tbody> </tbody>	0.00	40.00	0.00
1400046054	21-36883	R <tbody> </tbody>	40.00 <tbody> </tbody>	0.00	40.00	0.00
1400051174	21-36883	R <tbody> </tbody>	69.99 <tbody> </tbody>	0.00	40.00	0.00
1400045525	21-36883	R <tbody> </tbody>	79.99 <tbody> </tbody>	0.00	40.00	0.00
1400046927	21-36883	R <tbody> </tbody>	79.99 <tbody> </tbody>	0.00	40.00	0.00
1400046737	21-36883	R <tbody> </tbody>	79.99 <tbody> </tbody>	0.00	40.00	0.00

<tbody>
</tbody>

 

[JaneeBaker]

I've searched high and low for a good formula to find a minimum positive number with multiple conditions. I am needing help to write a formula that will populate the last three columns as shown. There are thousands of items in my report; I've only shown two of them. Is there anyone here who can help me?