=A1*A2 will multiply the values in A1 by A2 regardless of the cells having
constants or formulas
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"sazza26" wrote in message
...
How do you multiply two cells together without having an error message
show
up? One cell has the amount shown in dollars, the other is just normal.
The
formula doesn't shows up with errors, but don't know what formula i should
use.