| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Base amount
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) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Base amount
Not that I know what you are talking about (taxes?) but maybe it should be
=(MIN(B4:B15)*12)+(MIN(C4:C15)*12) -- Regards, Peo Sjoblom "Nicola H." wrote in message ups.com... 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) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Base amount
Thanks.
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Base amount
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 In article . com, "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) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Base amount
Oops, misread your parens - use Peo's formula instead.
In article , JE McGimpsey wrote: then your formula is correct |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Base amount
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change amount in figure to amount in words? | Excel Worksheet Functions | |||
| Formula for amount owing subtract amount paid | Excel Worksheet Functions | |||
| How can I calculate amount of time left based on amount spent? | Excel Worksheet Functions | |||
| Change base 6 to base 10? | Excel Discussion (Misc queries) | |||
| Converting amount in figures to amount in words | Excel Discussion (Misc queries) | |||
Hybrid Mode
