XLOOKUP is Excel’s modern fix for everything VLOOKUP got wrong. It’s simpler, more flexible, and available in Excel 365 and ...

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.

Here is what the formula would look like in Excel if we hard-coded the values: = (1000 * 3) - ( (1000 * 3) * 0.1) There are a couple of problems here that make this formula complex.