Showing the minimum value of two isolated cells excluding zeros

Ralley

New Member
Joined
Nov 9, 2011
Messages
15
Hi All,

Anyone's help on this would be appreciated. I have the following formula which works perfectly unless one of the cells has a value of zero;

=MIN(SUM(AD13),MIN(SUM(AK13)))

When AD13 = £60.00 and AK13 = £94.00 (or vice versa) the formula returns £60.00, which is correct. BUT when AK13 = £0.00 obviously the formula returns £0.00, but I would like the formula to still return £60.00.

Can anyone enlighten me on how this can be done?

Thanks in advance

Richard
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,701
Office Version
  1. 365
Platform
  1. Windows
Why are you using SUM(AD13) and not just AD13?
Try:
Code:
=IF(AD13*AK13=0,MAX(AD13,AK13),MIN(AD13, AK13))
 

Ralley

New Member
Joined
Nov 9, 2011
Messages
15
Why are you using SUM(AD13) and not just AD13?
Try:
Code:
=IF(AD13*AK13=0,MAX(AD13,AK13),MIN(AD13, AK13))

It was the only way I could get it to do what I wanted it to do, well, until I encountered a cell with zero in that is.

But anyway, your formula has worked perfectly and your help is gratefully received, cheers!
 

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,924
Members
414,416
Latest member
Nobu

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
Top