I am trying to set use Left Function.
For example:
Code: Select all
Column a Column b Column c
0.27±25 590 #VALUE!
please tell me what is mistake.
Thanks
Code: Select all
Column a Column b Column c
0.27±25 590 #VALUE!
Code: Select all
=VALUE(LEFT((A1;4))*B1
Code: Select all
=VALUE(LEFT((A1;FIND(".";A1)+2))*B1