To calculate the area of a rectangle in Excel, you need to multiply the length with height. That being said, use this formula: =<cell with length>*<cell with height> .

Suppose you frequently calculate the area of a rectangle. Instead of repeatedly typing out the formula, you can create a LAMBDA function like this: =LAMBDA(length, width, length * width) ...

The subject of a formula is the variable that is being worked out. It can be recognised as the letter on its own on one side of the equals sign. For example, in the formula for the area of a ...