Calculating a cell based on several criteria

[kcgojnur]

Hello I'm looking to figure out the best way to figure out a rate with multiple criteria.

If Cell 56 is not 7 or 15 I need to take the rate (Cell F56) - subsidy (C91) and select the minimum of that against rate (Cell C61). So whichever is the smallest should be selected. Then the minimum needs to be multiplied by cell C62 the answer should then be added by what is in cell C63 and C64.

If Cell 56 is a 7 or 15 I need to take the rate (cell F56) - subsidy (C89) and select the minimum of that against rate (Cell C61). So whichever is the smallest should be selected. Then the minimum needs to be multiplied by cell C62 the answer should then be added by what is in cell C63 and C64.

Also, the final answer should be rounded to the 2nd decimal place.

TIA

 

[thisoldman]

You don't tell us the column of Cell 56. You'll have to edit this formula before you try it.

This is what I came up with:
=ROUND(MIN(F56 - IF(OR(Cell_56=7, Cell_56=15), C89, C91), C61) * C62 + C63 + C64, 2)

 

[kcgojnur]

You don't tell us the column of Cell 56. You'll have to edit this formula before you try it.

This is what I came up with:
=ROUND(MIN(F56 - IF(OR(Cell_56=7, Cell_56=15), C89, C91), C61) * C62 + C63 + C64, 2)

Thanks for the response I'll give it a try. Also, cell 56 is is A56.

 

[kcgojnur]

Seems to work! Gonna test it some more. Wanted to add a small caveat to the formula. The above should only run if cell F5 = TRUE.

=IF(F5=TRUE,ROUND(MAX(F56 - IF(OR($C$56=7, $C$56=15), $C$88, $C$90), $C$61) * $C$62 + $C$63 + $C$64, 2),0)

?