How to get rid of VALUE! ???

[branek15]

Hi.

So...I have used this formula: =C10-((D10/C10)*100) to calculate a total price of a product with certain discount and got this text VALUE!

Can somebody please help me with this formula?

 

[BGY23]

Ensure that the cells you're using contain numbers and not text. if it's imported from another source ther may be trailing spaces so whilst it looks like a number it's actualy text and so you get Value#

 

[Andrew Poulsom]

What's in D10? You will get #VALUE! if it contains text.

=IF(ISNUMBER(D10),C10-((D10/C10)*100),"")

 

[BGY23]

I put the formula into my spreadsheet and it worked as expected.