Place formula and number in same excel cell

Copper Contributor

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

Hi @GALERIE_ROUSSIL 

 

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.

 

 

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$  ?