Limiting number of decimals in a VARIABLE SENTENCE

%3CLINGO-SUB%20id%3D%22lingo-sub-2144418%22%20slang%3D%22en-US%22%3ELimiting%20number%20of%20decimals%20in%20a%20VARIABLE%20SENTENCE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2144418%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20make%20a%20variable%20sentence%20that%20will%20show%20the%20calculations%20used%20to%20arrive%20at%20a%20number%20i.e.%20a%20unit%20cost*number%20of%20units%2C%20next%20to%20the%20result.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20currently%20using%3A%26nbsp%3B%3D%22%20%22%20%26amp%3B%20I52%20%26amp%3B%20%22%20X%20%22%20%26amp%3B%20H17%20%26amp%3B%20%22%20%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhich%20should%20give%20me%3A%20''unit%20value%22%20X%20%22number%20of%20units%22%26nbsp%3B%20%26nbsp%3B(i.e.%20%227%2C65%20X%2090%22%20)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%3A%20When%20calculating%20i.e.%20unit%20value%20in%20a%20different%20cell%2C%20the%20output%20comes%20out%20with%20many%20decimals%2C%20i.e.%207%2C65438828346%2C%20instead%20of%207%2C65.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20question%3A%20How%20do%20I%20limit%20the%20number%20of%20decimals%20in%20my%20variable%20sentence%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2144418%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

 

I am trying to make a variable sentence that will show the calculations used to arrive at a number i.e. a unit cost*number of units, next to the result.

 

I am currently using: =" " & I52 & " X " & H17 & " "

 

Which should give me: ''unit value" X "number of units"   (i.e. "7,65 X 90" )

 

The problem: When calculating i.e. unit value in a different cell, the output comes out with many decimals, i.e. 7,65438828346, instead of 7,65. 

 

The question: How do I limit the number of decimals in my variable sentence?

1 Reply

@Madsnielsen97 

For example:

 

=" " & TEXT(I52;"0,00") & " X " & TEXT(H17;"0,00") & " "

 

(I assumed that you are using comma as decimal separator)