Hello.



I have a formula currently as follows

Where G2 is the limit,C13 is one quote & D3 is another quote, E4 is a the final criteria.

The rows are G5:G10 (where the result populates)

Also range A1:A15 which is just quantity as a numeral

Also have I1:I15 which consists of different criteria to multiply the base quote against

Another cell range F is where I place a number from 1-15 to pull the data from range i1-i15

=IF(AND($F1=1,(ISNOTBLANK($E4), MIN($G$2,$C$13*I1,$D3*I1,$E4*A1,0,))

Is this formula right or the best formula to use? Want it to be validated only if the cells in the min formula are more than zero or not blank.

This result appears in the first row in the range (G5)

If the result means the limit (G2) is depleted, thus means any further results in the range must equal zero also,(G6-G10),how do I incorporate this into the formula?

The limit (G2) is/was $1,200.00 & now validated in (G5) as zero