Jan 21 2020 10:32 AM
What i wanted to know is whether there is a way to put a formula and then enter a number in the same excel cell.
For Ex:
Let say we are using C2 cell. I'd like to enter number 10.00$ in cell C2 and i want it to automatically remove 15 % of it and show me the result in C2 itself. Is there any way to do that?
Jan 22 2020 04:25 AM
The value of cell may be a Value or a Formula. The result of a formula is a value.
If you want remove the "%" (for exemple: 20%), returning the value of the "20%" (for exemple: 0,2), I sugest you try Number Format.
Jan 24 2020 10:21 AM
Hello@Paulo Junior Thank you for your time!
What type of number code i should create so that for example:
If i write 11.15$ in cell C2 and press enter, it automatically removes 15% of the number and shows 10.00$ ?