=NOT(ISBLANK( . . ))

=if(not(ISBLANK(C13)),if(not(ISBLANK(D8)), if(F8=1, MIN(G2, D8*I15, C13*I15, E8*A1, result in cell G9, $400.00 (as G2 is the lowest amount, D8 is zero/blank & C13 is zero/blank)

If the formula is then run again in the next row G10, how do I add to the formula so that it validates that G2 is now zero & no further limits/benefits are available

C13 is a set amount (a lump sum instead of individual amounts like D8) multiplied by I15 50% (benefits max 50% of this total)

D8 is a set quoted amount multiplied by a quantity A1*I15 being 50% (benefits max 50% of this total)

G2 is a limit remaining & the total available benefits

So the formula I created needs to ignore D8 or C13 is the cells are blank/zero & give the minimum of the remaining criteria being the minimum result as the benefits payable

The column I in the range I15:I20 contains several different validations such as by 50%,60%,80% 100%, 80% or item amount (whichever is lower) of quote again either C13 or D8 whichever is not blank/zero



Could I vlookup formula be incorporated maybe?

Thank you