[Solved] Use of Left Function

[Idrees Khan]

Hello,
I am trying to set use Left Function.
For example:

Code: Select all

Column a          Column b            Column c
0.27±25	        590	              #VALUE!

=left(A1;4)*(B1) its Result Came is #value
please tell me what is mistake.
Thanks

[robleyd]

You are trying to multiply a text value (result of the LEFT function) and a number (590)

The VALUE function, used to convert the result of LEFT to number, will give you what you want. Note the brackets around B1 are not needed.

[Idrees Khan]

I want to multiply Column a first 4 digit with column b value

[Lupp]

See viewtopic.php?t=39529.

Entered constants and also the results returned by formulae have a type each.
The LEFT() function returns a result of type 'Text'. To apply a multiplication you need something of type 'Number'.
Try

Code: Select all

=VALUE(LEFT((A1;4))*B1

where the VALUE() function converts the text to a number if possible. The working of VALUE() depends on the decimal separator of your locale. To get your formula to work also in locales using the decimal comma, you need to accept some complications.

[njhub]

Hello, try

Code: Select all

=VALUE(LEFT((A1;FIND(".";A1)+2))*B1

(+2) two digits after dot

[Idrees Khan]

Thank you Lupp for your help