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

[Joe1017]

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

 

[Scott Huish]

Sure, with this UDF:

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]

Why would you want to do that?

 

[Joe1017]

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

 

[jtakw]

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
	A	B
1	<2568	1284
Sheet1

Cell Formulas
Range	Formula
B1	=IF(LEFT(A1,1)="<",RIGHT(A1,LEN(A1)-1)/2,"")

 

[Joe1017]

https://drive.google.com/file/d/0B_b-_Fpw1jN0MFl3MDNzNnAtcXc/view?usp=sharing


​Try this

 

[Scott Huish]

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

Confirm with CTRL-SHIFT-ENTER rather than just Enter