# using a symbol preceding a number to = 1/2 the number value

#### Joe1017

##### New Member
Is there a way to use a symbol < in excel preceding a number to equal half of that number's value?
Example: <1+<2=1.5
.5+1=1.5

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### Scott Huish

##### MrExcel MVP
Sure, with this UDF:

Code:
``````Function EvalAsHalf(r As String)
EvalAsHalf = Evaluate(Replace(r, "<", ".5*"))
End Function``````

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td><td >B</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td ><1+<2</td><td style="text-align:right; ">1.5</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >B1</td><td >=EvalAsHalf(A1)</td></tr></table></td></tr></table> <br /><br />

#### galt13

##### Board Regular
Why would you want to do that?

#### Joe1017

##### New Member
I NEED A FORMULA THAT WILL RECOGNIZE THE < SYMBOL HERE IS A PICTURE. file:///C:/Users/Joe/Downloads/Screenshot_20160314-190955.webp

#### jtakw

##### Well-known Member

I NEED A FORMULA THAT WILL RECOGNIZE THE < SYMBOL HERE IS A PICTURE. file:///C:/Users/Joe/Downloads/Screenshot_20160314-190955.webp

Hi,

That is a link to YOUR computer hard drive, unless you also post your street address, no one will be able to see it. You need to upload to a file server.

If the cell in question contains only one value, then:

Excel 2010
AB
1<25681284
Sheet1
Cell Formulas
RangeFormula
B1=IF(LEFT(A1,1)="<",RIGHT(A1,LEN(A1)-1)/2,"")

#### Scott Huish

##### MrExcel MVP
=SUM(IF(LEFT(D2:D29)="<",MID(D2:D29,2,255)*0.5,D2:D29))

Confirm with CTRL-SHIFT-ENTER rather than just Enter

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,164,624
Messages
5,838,425
Members
430,546
Latest member
CometOz

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back