Place formula and number in same excel cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1120741%22%20slang%3D%22en-US%22%3EPlace%20formula%20and%20number%20in%20same%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1120741%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWhat%20i%20wanted%20to%20know%20is%20whether%20there%20is%20a%20way%20to%20put%20a%20formula%20and%20then%20enter%20a%20number%20in%20the%20same%20excel%20cell.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20Ex%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ELet%20say%20we%20are%20using%20C2%20cell.%20I'd%20like%20to%20enter%20number%2010.00%24%20in%20cell%20C2%20and%20i%20want%20it%20to%20automatically%20remove%2015%20%25%20of%20it%20and%20show%20me%20the%20result%20in%20C2%20itself.%20Is%20there%20any%20way%20to%20do%20that%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1120741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1122244%22%20slang%3D%22en-US%22%3ERe%3A%20Place%20formula%20and%20number%20in%20same%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1122244%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F527316%22%20target%3D%22_blank%22%3E%40GALERIE_ROUSSIL%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20value%20of%20cell%20may%20be%20a%20Value%20or%20a%20Formula.%20The%20result%20of%20a%20formula%20is%20a%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20remove%20the%20%22%25%22%20(for%20exemple%3A%2020%25)%2C%20returning%20the%20value%20of%20the%20%2220%25%22%20(for%20exemple%3A%200%2C2)%2C%20I%20sugest%20you%20try%20Number%20Format.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-and-apply-a-custom-number-format-6c308025-35da-4047-9481-c146a12063df%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fcreate-and-apply-a-custom-number-format-6c308025-35da-4047-9481-c146a12063df%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fnumber-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fnumber-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68%3C%2FA%3E%3C%2FLI%3E%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfjyOG7Ls7BA%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DfjyOG7Ls7BA%3C%2FA%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1128007%22%20slang%3D%22en-US%22%3ERe%3A%20Place%20formula%20and%20number%20in%20same%20excel%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1128007%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F28784%22%20target%3D%22_blank%22%3E%40Paulo%20Junior%3C%2FA%3E%26nbsp%3B%20Thank%20you%20for%20your%20time!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20type%20of%20number%20code%20i%20should%20create%20so%20that%20for%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20write%2011.15%24%20in%20cell%20C2%20and%20press%20enter%2C%20it%20automatically%20removes%2015%25%20of%20the%20number%20and%20shows%2010.00%24%26nbsp%3B%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New 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
Highlighted

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.

 

 

In this video, you'll learn more about number formats in Excel 2019, Excel 2016, and Office 365. Visit https://edu.gcfglobal.org/en/excel/understanding-numbe...
Highlighted

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