Hello,
Can anyone please help make formula which I can multiply 2 cells and have X from column A as the value 0 when multiplied, e.g, looks like row 5 from from this Data table. And if possible, make the formula turn the Total Amount as XXX as the value for 0, e.g. look like row 4. If not possible, I'm happy if anyone can just make the formula which X is the value 0 on Column A when multiped with Column B on Column C
Can anyone please help make formula which I can multiply 2 cells and have X from column A as the value 0 when multiplied, e.g, looks like row 5 from from this Data table. And if possible, make the formula turn the Total Amount as XXX as the value for 0, e.g. look like row 4. If not possible, I'm happy if anyone can just make the formula which X is the value 0 on Column A when multiped with Column B on Column C