Forum

Notifications
Clear all

Automatic percentage calculation of value but in the same cell value being entered

3 Posts
2 Users
0 Reactions
89 Views
(@scorpioix)
Posts: 1
New Member
Topic starter
 

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.

 
Posted : 04/12/2021 12:59 pm
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

Hello,

You need to play around creating some conditional rules to control what custom number format should be applied. I wonder of what good usage such scenario could be. Anyway, here is a good guide on how to play around with custom formatting.

https://www.myonlinetraininghub.com/excel-custom-number-format-guide

Br,
Anders

 
Posted : 04/12/2021 6:26 pm
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
Share: