Merge Many Formula with airSlate SignNow

Merge formula accreditation

here I'll show you how to put multiple sum functions within one max function and this is really just nesting functions within Excel the benefit of this is that we can do relatively complex calculations within one cell as opposed to having multiple cells within the worksheet that contain data that works up to that final result so here I'm just going to do a sum of this set of numbers this set of numbers and see which one is greater now this is a very simple example that I'm using just to show you how you can nest functions but you can do this with considerably more complicated functions such as another tutorial where I show you how to nest one vlookup function into another vehicle function so here I've got the functions we're going to be using this is the max function with its arguments one sub function and another sub function now for all three of these functions you can have a number of arguments you can have one two three four you can have many different ones that's why the three dots is at the end of the max function and it's actually the same for the sum function as well that's because you could do a max of one number two numbers three numbers and so on now if we are going to do a max to see which number or set of numbers is greater what we could do is equals some select data equals some select the data and then up here we could do the max function equals max and select the result of the sum functions so we can see that 26 is higher than 20 well now what I'm going to show you how to do is to put the sum function into the max function so all that you really have to do is put this sum function in place of number one so the argument for number one and the second sum function in place of the argument for number two so now let's delete these and it goes equals max now instead of selecting a number we're going to nest the sum function in here for this argument so we start typing some notice we get a list of arguments just like we did for when we typed in equals max let's sum the first set of numbers now it's very important to make sure you close the parentheses that will take you out of the sum function and back into the max function now hit comma to go to the second argument in the max function start typing some and select the set of numbers right here remember closed the parentheses for the sum function that puts us back in the max function and now since we're done with the max function close the parentheses for the max function hit enter and we get the same result 26 this time however we did everything in the...