0
What other functions can be used in conjunction with the SUM function to replace the sum range function argument?
Wiki User
∙ 10y ago
Any function that generates a number, so there is a huge amount of them. You could for example use the MAX function to the get the highest of a range of values and put it in with several others and get something like this:
=SUM(MAX(A1:A12),MAX(B1:B12),MAX(C1:C12))
However, such a calculation could be done without the SUM like this:
=MAX(A1:A12)+MAX(B1:B12)+MAX(C1:C12)
So a SUM function is best used with ranges, as that is its main purpose.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
How do you evaluate functions?
To evaluate a function means to replace the variable with some value, and calculate the value of the function. For example, in the parabola y = x2 (or, using functional notation, f(x) = x2), if you replace x with 10, and calculate x2, you are evaluating the function for that specific value.
What is the conjunction in this sentence The house was damaged by the tornado but it could be repaired?
"but" If you can take the word out and replace it with a full stop or a semi colon, it is a conjunction.
What are differences between replace and substitute Microsoft Excel functions?
The Replace function replaces part of a text string, based on the number of characters you specify, with a different text string. The Substitute function substitutes newtext for old text in a text string. You use Substitute when you want to replace specific text in a text string and you use Replace when you want to replace any text that occurs in a specific location in a text string.
Which of the folloving is a function of proteins?
First of all, I do not know what folloving means. Let's just replace it with 'following.' The function of proteins is the creation of your beloved mother. I'm not joking, proteins have functions to create human body. Hope this helped :)
Can you use a comma to replace a conjunction in a compound sentence?
No, but you may be able to use a semicolon. A semicolon and a conjunctive adverb can sometimes take the place of a subordinating conjunction.
Can you replace a formula with its function so it can remain constant?
No but if you replace a constant with a function it will remain a formula
Can you replace a formula with its function so it remains constant?
No but if you replace a constant with a function it will remain a formula
Words that can replace the word- SO?
Words that can replace the conjunction "so": "Therefore" "Whereas" "Thus" "Accordingly" "Whence"
What is the function of the replace parameter in Oracle?
The function of the replace parameter in Oracle is to replace a sequence of characters in a string with other characters, usually in sets of characters.
Which text function replaces text in a string?
The REPLACE function.
What are php functions?
A function is a set of commands. These commands usually call other, more basic functions and called one after the other they work together to archive a certain objective, sometimes simple, sometimes complex. Say the purpose of the function is to erase all hyphen (-) and at (@) characters in some text. The function will is accept a parameter (the text) and return a value (the formatted text). Here's how that would look in the code... function strip_slashes ($text) { return str_replace(".", "", str_replace("@", "", $text)); } This code creates a function called "strip_slashes", the function accepts the "$text" parameter and then runs the built in PHP function "str_replace" twice to replace the @ and - characters with nothing (effectively erasing them). In the same line we tell our function to "return" the results of our two "str_replace" functions. PHP has over 700 built in functions able to do just about anything you can think of. If it's not there, likely because it's very specific to your application, then you can simple write it yourself.
Which function is similar to the Find and Replace feature in excel?
the SUBSTITUTE function
