Multiplying cells with formula's

[sazza26]

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.

 

[Bernard Liengme]

=A1*A2 will multiply the values in A1 by A2 regardless of the cells having
constants or formulas
best wishes

 

[paul]

if you type out the $ sign and a numeral excel should interpret that as
currency and still come up witht he answer you want

 

[sazza26]

It's linked to a spreadsheet, and everytime the data refreshes it makes an
error in the formula. It seems to dislike the $ sign in one of the columns.
Any way around it?

 

[David Biddulph]

If you want help, it is always better to tell the group *what error* you are
seeing, rather than just saying "an error", and leaving the members to guess
which error.

Perhaps your windows regional settings don't expect a $ sign for currency,
but may be set up for a £ or other currency symbol? If so, it will regard
your string with a $ as being a text string, not a number, and give a
#VALUE! error when you try to multiply.