Use the number part

R

Rudy

Sometimes I have data which I enter as : <0.05
How do I get Excel to use the cell's entry as 0.05 for further calculations?
 
K

Ken Johnson

Sometimes I have data which I enter as : <0.05
How do I get Excel to use the cell's entry as 0.05 for further calculations?
Click to expand...

When in A1, maybe...

=VALUE(MID(A1,2,255))

Ken Johnson
 
S

Sandy Mann

If Say you wanted to add it to the value in D4 then try:

=D4+(--SUBSTITUTE(D12,"<",""))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
D

Dave Peterson

Just to add to Sandy's reply...

Since his formula is using the addition operator (or any arithmetic operator),
the -- stuff isn't necessary.

=D4+SUBSTITUTE(D12,"<","")
should work ok.
 
Top