if(iserr) question

[tmiao]

=IF(AD36<=12,((AD$24*AN36)/AN36),AD36),IF(AD36=0,0)

how do i use the if iserr in this. it works when i have a number in cell AD36, bout it won't work when cell AD36=0??

AD=11 (which i have to make the min to be 12), and if AD36=0, then i want the result to be 0

please help!!!

 

[Andrew Poulsom]

Does this work for you?

=IF(AD36<=12,((AD$24*AN36)/AN36),AD36)