Multiple IF AND Statements

[danniaus]

Hello

If I have the following sets of data

Cell K2 = 750000
Cell N9 = YES
Cell B32 = 15

What formula can I use to say the following

If Cell K2 >500000 and Cell N9 = YES and B32 is less than or equal to 20 then use the the value in cell B32, if it is greater than 20 then use 20

I hope that makes sense

Any help appreciated

 

[Yongle]

This equates to

ZERO when either K2 or N9 conditions not satisfied

Otherwise to 20 OR the value in B32 when less that 20

=AND($K$2>500000,$N$9="YES")*MIN(20,$B$32)


To avoid the ZERO when K2 or N9 not satisfied

=IF(AND($K$2>500000,$N$9="YES"),MIN(20,$B$32),"")

NOTE
To drag the formula down a column you need to alter one or more absolute reference (perhaps replace $K$2 with K2)