Base amount

  • Thread starter Thread starter Nicola H.
  • Start date Start date
N

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)
 
Not that I know what you are talking about (taxes?) but maybe it should be

=(MIN(B4:B15)*12)+(MIN(C4:C15)*12)
 
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
 
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
 
Back
Top