Multiplying cells with formula's
 

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.

Multiplying cells with formula's
 

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

Multiplying cells with formula's
 

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

remove nospam for email addy!



"Bernard Liengme" wrote:

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

Multiplying cells with formula's
 

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?

"paul" wrote:

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

remove nospam for email addy!



"Bernard Liengme" wrote:

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

Multiplying cells with formula's
 

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.
--
David Biddulph

"sazza26" wrote in message
...
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?

"paul" wrote:

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

remove nospam for email addy!



"Bernard Liengme" wrote:

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