If I understand correctly, all you need to do is include the additional range
in your original MIN function.

=MIN(B4:C15)*12

HTH,
Elkar


"Nicola H." wrote:

I am tring to find the base amount and this is the formula I am
currently using =MIN(B4:B15)*12

However now it needs to reflect (B4:B15)*12 and (C4:C15)*12 do I just
add them so he formula would be =MIN((B4:B15)*12+(C4:C15)*12)