Log In
Register
Home
New Member
December 4, 2021
Offline
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.
VIP
Trusted Members
December 7, 2016
Offline
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.myonlinetraininghu.....rmat-guide
Br,
Anders
1 Guest(s)
