Excel and formulas

Excel and formulas Useful Excel formulas A collection of ready-to-copy Excel formulas in Italian and English. Excel and formulas Excel formula to calculate a percentage Excel formula to calculate a percentage of a number. Excel and formulas Excel formula for VAT and reverse VAT Excel formulas to add VAT or reverse VAT from a gross amount. Excel and formulas Excel formula for date difference Excel formula to calculate days, months or years between dates. Excel and formulas Excel formula to keep text before a character Excel formula to remove everything after a character. Excel and formulas Excel formula to keep text after a character Excel formula to extract text after a specific character. Excel and formulas Excel IFERROR formula How to use IFERROR in Excel to show an alternative value when a formula returns an error. Excel and formulas Excel formula to look up a value Examples of VLOOKUP and XLOOKUP formulas. Excel and formulas Excel SUMIF formula Excel SUMIF and SUMIFS formulas to sum values with conditions. Excel and formulas Excel VLOOKUP formula VLOOKUP formula to search for a value in an Excel table. Excel and formulas Excel COUNTIF formula COUNTIF formula to count cells matching one condition. Excel and formulas Excel formula to trim spaces TRIM formula to remove extra spaces from an Excel cell.