Multiplication formula

Zitong

Hello All,

There is a question for multiplication formula. the one of cell is a formula, i need to use the price of this cell to multiply, but showed incorrect. Like below. Please help.

Thanks in advanced.

Zitong

Paul Newcome

The circular reference error means that you are putting the formula into a cell that is being referenced by the formula. Try moving it to another column.

Paul Newcome

The circular reference error means that you are putting the formula into a cell that is being referenced by the formula. Try moving it to another column.

Zitong

Thanks, Paul.

Paul Newcome

Happy to help. 👍️