Decrease decimal number after add unit in excel

[mazan2010]

Dear All Expert
my problem is when i add unit to my value in excel , its increase decimal number lie the following
my formula is
=(1.1*1.5*(LEFT('A1'!B6,FIND(" ",'A1'!B6)))/1.03)& " {ml} "
result come as the following
86.504854368932 {ml}
how can make this
86.5048 {ml}

[AliGW]

Like this:

=ROUND((1.1*1.5*(LEFT('A1'!B6,FIND(" ",'A1'!B6)))/1.03),4)& " {ml} "

[Glenn Kennedy]

It must be a very high precision application, if you want an answer to 0.1 µL !!!

[joeu2004]

=TRUNC(1.1*1.5*(LEFT('A1'!B6,FIND(" ",'A1'!B6)))/1.03, 4) & " {ml}"

But if you would like to reference the numeric result in other arithmetic expression:

=TRUNC(1.1*1.5*(LEFT('A1'!B6,FIND(" ",'A1'!B6)))/1.03, 4)

formatted as Custom 0.0000" {ml}"

[AliGW]

Thanks fort he rep!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[joeu2004]

result come as the following 86.504854368932 {ml}
how can make this 86.5048 {ml}

=ROUND((1.1*1.5*(LEFT('A1'!B6,FIND(" ",'A1'!B6)))/1.03),4)& " {ml} "

=TRUNC(1.1*1.5*(LEFT('A1'!B6,FIND(" ",'A1'!B6)))/1.03, 4) & " {ml}"

Thanks fort he rep!

Mazan did what?!

When A1!B6 contains "54 ml", for example, the unrounded formula results in 86.504854368932.

ROUND(...,4) results in 86.5049.

TRUNC(...,4) results in 86.5048.

Mazan stated that he wants the latter.

Mazan, did you misstate your requirement, and AliGW stumbled onto the correct(ed) solution by luck?

[AliGW]

There was no stumbling or luck involved! I had not read the last line of the requirement, however, so ROUNDDOWN would be better.

Please note that rep points are awarded at the OP's discretion.