It really is dependent upon that problem you are trying to solve.But it really isn't all that more complex if you approach it from the right perspective.Every functions has what is called "arguments" (some may call them "inputs"). Most of the time, you enter hard-coded values in for these arguments. But you can also place functions in place of these arguments, if they are of the correct data typeHere is an example of one I helped someone out with earlier today:
https://www.mrexcel.com/forum/excel...creating-problem-mina-newbie.html#post5084069With the MINA function, you return the minimum value of a set of values.So, "simple" examples may look like:
=MINA(4,7,9)or
=MINA(A1,C1,E1)or
=MINA(A1:A3) But what if you wanted the minimum amount of three SUMs? Simply replace the argument with your SUM functions, like I did there:
=MINA(SUM(A3:B3),SUM(C3:E3),SUM(F3:G3)Another example is a simple IF statement like this:
=IF(A1=1,"Yes","No)Now what if we want to return "Yes" if A1 is 1 or 2?Simply replace the first argument of the IF function with the OR function, i.e.
=IF(OR(A1=1,A1=2),"Yes","No)So it is really just a matter of using other functions/formulas in the arguments of other functions (think "substitution").The best advice I can give you is to start simple, breaking it down to a simple formula first, and work you way up but substituting in those parts, one-by-one.