Formulas in Excel

Copper Contributor

How can I have a column for Quantity and another column where I put a dollar amount in. For example, qty 4 

DOLLAR AMOUNT for each $25.00

then total in the next column $100

Sorry it's kinda hard to explain .

1 Reply

@Jfrancoeur73 Suppose you have quantity in A1 cell and rate in B1 cell. Then put below formula to C1 cell.

=A1*B1