Showing the minimum value of two isolated cells excluding zeros

[Ralley]

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

 

[JackDanIce]

Why are you using SUM(AD13) and not just AD13?
Try:

=IF(AD13*AK13=0,MAX(AD13,AK13),MIN(AD13, AK13))

 

[Ralley]

Why are you using SUM(AD13) and not just AD13?
Try:

=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!

 

[JackDanIce]

You're welcome, glad it works