G

#### Guest

separate column (Col I) I wish to always have the 2 lowest value from the

random numbers ... The following formula achieves this for me, but I am

thinking there might be a simpler way of writing??? One clarifier ... In the

following Formula Col H contains a Qty which I wish to multiply the 2nd

lowest value in Range C12:G12 by.

=IF(MIN(C12:G12)=MAX(C12:G12),MAX(C12:G12)*H12,IF(SMALL(C12:G12,2)>MIN(C12:G12),SMALL(C12:G12,2)*H12,IF(SMALL(C12:G12,3)>MIN(C12:G12),SMALL(C12:G12,3)*H12,IF(SMALL(C12:G12,4)>MIN(C12:G12),SMALL(C12:G12,4)*H12,(MAX(C12:G12)*H12)))))

Thanks ... Kha