This page provides examples of how to use

**excel formulas**to perform many common tasks. Although many people use the term ‘Excel Formulas’ to refer to the Excel Built-In Functions, the term ‘Excel Formula’ can encompass a wider range of operations in Excel. Therefore on this site, when we use the term ‘Excel Formulas’ (or ‘Excel Formulae’), we are generally referring to any combination of Excel Operators and/or Excel Functions. This may be as simple as a basic addition (eg. “=A1+B1”), or it could be a complex combination of Excel Operators and multiple nested Excel Functions.**Web : excel**

Filter:

### Sum

Filter:

### Average

Formula | Related Functions |
---|---|

Average numbers | AVERAGE |

Average numbers ignore zero | AVERAGEIF |

Average top 3 scores | AVERAGELARGE |

Weighted average | SUMSUMPRODUCT |

### Min and Max

Filter:

### Conditional Formatting

Filter:

### Lookup

Filter:

### If

Filter:

### Round

Filter:

### Date And Time

Filter:

### Date Series

### Text

Filter:

### Finalcial

Formula | Related Functions |
---|---|

Calculate compound interest | FV |

Calculate simple interest |

### Workbook

### Internet

Formula | Related Functions |
---|---|

Get domain from email address | FINDLENRIGHT |

Get domain name from URL | FINDLEFT |

Get name from email address | FINDLEFT |

Get top level domain (TLD) | FINDLENRIGHTSUBSTITUTE |

### Names

### Percentage

Filter:

### Range

Filter:

### Miscellaneous

Filter:

Advertisements