Forum Discussion
Place formula and number in same excel cell
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?
2 Replies
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.
- https://support.office.com/en-us/article/create-and-apply-a-custom-number-format-6c308025-35da-4047-9481-c146a12063df
- https://support.office.com/en-us/article/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68
- https://www.youtube.com/watch?v=fjyOG7Ls7BA
HelloPaulo 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$ ?
