Base amount

[Nicola H.]

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)

 

[Peo Sjoblom]

Not that I know what you are talking about (taxes?) but maybe it should be

=(MIN(B4:B15)*12)+(MIN(C4:C15)*12)

 

[JE McGimpsey]

What does "reflect" mean to you?

If reflect means that you want the minimum number in B4:B15 multiplied
by 12 added to the minimum number in C4:C15 multiplied by 12, then your
formula is correct, though it could also be written slightly more
efficiently as

=(MIN(B4:B15)+MIN(C4:C15))*12

If reflect means that you want the minimum number in the range B4:C15
multiplied by 12, then use

=MIN(B4:C15)*12

 

[Nicola H.]

Thanks.

 

[Guest]

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

 

[JE McGimpsey]

Oops, misread your parens - use Peo's formula instead.