New to excel - Multiply
 

All I want to do is multiply a number times a $ amount.

Example

175 X $29.95

Please help with the formula.

Thanks

Hi

as per your other post....

=175*29.85
(and format as desired)

if cell references
=A1*B1

Cheers
julieD

"Markus Farrar" <Markus wrote in message
...
All I want to do is multiply a number times a $ amount.

Example

175 X $29.95

Please help with the formula.

Thanks

With 175 in cell A1 and 29.95 in cell A2, in A3 enter the formula:

=A1*A2

Alternatively, if you want to work in a single cell, enter:

=175*29.95

In either case, in order to display the result as a dollar amount. you
should format the result cell as currency.


---
Regards,
Norman



"Markus Farrar" <Markus wrote in message
...
All I want to do is multiply a number times a $ amount.

Example

175 X $29.95

Please help with the formula.

Thanks