New to excel - Multiply

M

Markus Farrar

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

Example

175 X $29.95

Please help with the formula.

Thanks
 
J

JulieD

Hi

as per your other post....

=175*29.85
(and format as desired)

if cell references
=A1*B1

Cheers
julieD
 
N

Norman Jones

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.
 
Top