Enter a value and automatically perform a formula on it

Hi,

Here’s my problem. I want to inter a value in E4 (let say 7) and I want to calculate 5,58% of that value. I want the result (0,39) to be in the same E4 cell. I other words, I want to be able to inter a value in E4 make it become the result of X5,58/100 automatically. I tried things with conditional formatting and with format cell and noting seems to work… I got close with custom format in this post but it doesn’t do what I need.

http://www.excelforum.com/excel-gene...same-cell.html

It seems something that should be easy to do but I realise that it’s not!

Try this..

Press Alt + F11 and click Sheet1 in the tree tab in the left side..

Please Login or Register  to view this content.

Don't forget to click *