Hi,
I want the cell (in which I type some numerical value) to show a certain percentage of the entered value (say 40 %) but in the same cell instead of actual value entered. For example if I type let say 100 in the cell A1, the same cell should now show a certain percentage of the entered value (say 30 or 40 % whatever required) instead of showing the entered value. Like in cell formatting, we can program the cells to show the entered values in different styles/ways but underlying actual value remains same.