Need help with MIN IF AND

Microsoft Office Forums

		Microsoft Office Forums > Microsoft Excel > Excel
Need help with MIN IF AND

Prev

Previous Post

Next Post

Next

#1

Old

06-26-2015, 03:38 AM

tinfanide

tinfanide is offline

Need help with MIN IF AND

Windows 7 64bit Need help with MIN IF AND

Need help with MIN IF AND

Office 2010 32bit

Expert

Need help with MIN IF AND

Join Date: Aug 2011

Posts: 312

tinfanide is on a distinguished road

Default

Need help with MIN IF AND

From A1 to A6:
4,0,5,1,2,3

Code:

=MIN(IF($A$1:$A$6<>0,IF($A$1:$A$6<>1,$A$1:$A$6)))

This formula, with the use of nested IF, works. (Return: 2)

Code:

=MIN(IF(AND($A$1:$A$6<>0,$A$1:$A$6<>1),$A$1:$A$6))

This formula, with the use of AND inside IF, does not work. (Return: 0)

I'd like to ask how to make the second formula (use of AND) works.

Many thanks!

Reply With Quote

« Previous Thread | Next Thread »

Other Forums: Access Forums

All times are GMT -7. The time now is 08:01 AM.