# =\$D2*3.5 Formula gave wrong answer. Why?

Occasional Contributor

# =\$D2*3.5 Formula gave wrong answer. Why?

In Excel,
"=\$D2*3.5" Formula gave wrong answer. Why?

7 Replies

# Re: =\$D2*3.5 Formula gave wrong answer. Why?

What do you have in D2? What is the result you're looking for? We need some more information. Thanks!

# Re: =\$D2*3.5 Formula gave wrong answer. Why?

In the field D2 is the number 4. In the field D3 is the formula=\$D2*3.5 The answer it gave was 12.5, and obviously should have been 14.

# Re: =\$D2*3.5 Formula gave wrong answer. Why?

I have a column of numbers I want to multiply by 3.5, but the formula isn't generating true numerical values.

# Re: =\$D2*3.5 Formula gave wrong answer. Why?

In the field D2 is the number 4. In the field D3 is the formula=\$D2*3.5 The answer it gave was 12.5, and obviously should have been 14.I have a column of numbers I want to multiply by 3.5, but the formula isn't generating true numerical values. I just spot checked some of the other numbers, after copying the formula. They answers are close, but not as exact as my calculator. Excel is not making my life easier if it won't compute simple math accurately.

# Re: =\$D2*3.5 Formula gave wrong answer. Why?

I doubt the number in D2 is actually 4. The number displayed is not necessarily the exact value of the number in the cell, depending on formatting. If you change the cell formatting for D2 to show more decimals, what do you get?

# Re: =\$D2*3.5 Formula gave wrong answer. Why?

@JMB17  You were correct! I changed the cell formatting in D2 to "general" instead of "Number" and it's working more accurately now.  Thanks so much!

You're welcome.