Formula error resulting in 0.00%

[georgekeriakes]

Hey guys,

I am trying to add 40% to a column of numbers using this formula : =D5*(1+40%)

Once I hit enter, the result is 0.00%

What does that mean!?

It's not a huge excel sheet but there is a lot of other formulas in a couple of columns, can that be the problem?

Help please!!

[Jonmo1]

D5 must be 0

or maybe you have a circular reference in the sheet.

Can you attach an example file?