Criteria
Any action specified, through something like an IF function or Conditional Formatting, will happen.
You can have up to 255 conditions in the AND function.
Function
A nested if.
There is no function of that name in Excel. There is a function called VLOOKUP which stands for Vertical Lookup, and is probably what you mean.
There is a function called FIND and a function called SEARCH in Excel. There are other functions that can be used to find things, such as the various lookup functions.
Use the TRUNC function. You can specify the value and the amount of decimal places you want. =TRUNC(A2,1)
SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.SUM is the name of an actual function. It totals up values. So they are the same thing. There is no function called total in Excel, but it is a general term we use in describing what the SUM function can do.
The COUNT function will do it. You just need to specify your table range. Say your table is from B2 to E16, then the function would be: =COUNT(B2:E16)
In Excel a function within another function would be called a nested function.
hlookup
You can use the IF function to do calcutions based on conditions. You can also use SUMIF, COUNTIF and AVERAGEIF to do calculations too.