ExcelBanter - Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula (https://www.excelbanter.com/excel-discussion-misc-queries/121788-formula.html)

Danny Mac

Formula

How do i get a3 (a quantity) to multiply c3 to total in d3?

Ian

Formula

In D3 put =A3*C3

--
Ian
--
"Danny Mac" wrote in message
...
How do i get a3 (a quantity) to multiply c3 to total in d3?

Mike Rogers

Formula

Danny

In d3 put =a3*c3

Mike Rogers

"Danny Mac" wrote:

How do i get a3 (a quantity) to multiply c3 to total in d3?

CLR

Formula

Hi Danny Mac..........
You say clearly that A3 is a quantity, but do not so indicate for C3. If C3
is TEXT, then this formula in D3 may be of use.........

=REPT(C3,A3)

hth
Vaya con Dios,
Chuck, CABGx3

"Danny Mac" wrote:

How do i get a3 (a quantity) to multiply c3 to total in d3?

David Biddulph

Formula

If you are saying that you want D3 to contain the result of A3 multiplied by
C3, then in D3 insert the formula =A3*C3.
--
David Biddulph

"Danny Mac" wrote in message
...
How do i get a3 (a quantity) to multiply c3 to total in d3?

All times are GMT +1. The time now is 04:12 AM.